DEV Community

Discussion on: The SQL I Love. Efficient pagination of a table with 100M records

Collapse
bjacquemont profile image
Benoit Jacquemont

It's a very similar approach to the "Search After" feature of Elasticsearch (elastic.co/guide/en/elasticsearch/...), which has exactly the same problem with the "classical" offset/limit pagination.

By the way, using this method with MySQL too, for a WebAPI used to download all entities of a DB.

Thanks for documenting it!