You Are Doing SQL Pagination Wrong

Almost all applications using SQL fall into this common performance trap. Avoid it now!

Every application faces these issues in its early stages: you have to limit the quantity of data sent to a client for its requests to prevent your quality of service to degrade. We find this pattern everywhere:

The delicate part becomes “how we implement this solution?”.

We are going to look here at a simple use case, for pagination with a table object of 1000000 rows. We are…