Klaus

What’s wrong with pagination?

 Fri, 19 Aug 2016 17:00:46 +0200 
Why Most Programmers Get Pagination Wrong
Pagination is one of those things that almost everyone gets wrong for two reasons:
User experience
Database performance

Here’s why...


TL;DR: OFFSET pagination bad. Keyset pagination good.

This is always amusing:
Due to Oracle license restrictions, we cannot publish benchmark results here, comparing Oracle with PostgreSQL