Pagination without offset
Offset instructs the databases skip the first N results of a query. However, the database must still fetch these rows from the disk ,and bring them in order before it can send the following ones.
In this article, we look into a method to pagination records from query without using object. Napkin math has an interesting post discuss why offset is very expensive too
Appears in lists (1)
More like this (3)
Evolving API Pagination at Slack Pagination is a fundamental features of almost all web application. Paginate...Evolving API Pagination at Slack Pagination is a fundamental features of almost all web application. Paginate without duplicating item or missing new item isn’t trivial.