Markus Winand personal blog

OFFSET is bad for skipping previous rows

by @MarkusWinand use-the-index-luke.com 11 min read

OFFSET doesn’t deliver stable results and makes the query slow. Key-set pagination does neither.

Points

0

HN comments

0

Submissions

0

Cited by

11 commenters

Databases & DataSoftware Engineering2016

Related posts from the same era

RethinkDB is shutting down

RethinkDB Blog20161,674 points441 commentscited by 9 details

Announcing SQL Server on Linux

Microsoft Blog20161,344 points476 commentscited by 5 details

Why we lost Uber as a user

PostgreSQL20161,234 points285 comments details

Introducing Cloud Spanner, a Global Database Service

Google Cloud Blog20171,068 points434 comments details

Top Books on Amazon Based on Links in Hacker News Comments

Ramiro Gómez20161,043 points181 commentscited by 8 details

PostgreSQL 10 Released

PostgreSQL20171,024 points296 comments details