#Covering-Indexes

Efficient Pagination Using Deferred Joins

The article compares offset/limit and cursor pagination, then shows how deferred joins and covering indexes can make offset/limit fast enough for deep paging in MySQL and Laravel.