Efficient Pagination Using Deferred Joins
Paginating records across large datasets in a web application seems like an easy problem that can actually be pretty tough to scale. The two main pagination strategies are offset/limit and cursors.
We'll first take a look at the two methods and then a slight modification that can make offset/limit extremely performant.
Source: Efficient Pagination Using Deferred Joins, an article by Aaron Francis.