Nov 12, 2022 · Databases

How to Speed Up Large Pagination Queries in MySQL: Delayed Join and Bookmark Techniques

This article explains why traditional ORDER BY … LIMIT pagination becomes slow on tens of millions of rows, analyzes the underlying index scan cost, and presents two practical optimizations—delayed join using covering indexes and a bookmark‑based approach—showing how they can cut execution time to a third or even a tenth of the original.

bookmark paginationdelayed joinmysql

0 likes · 8 min read

How to Speed Up Large Pagination Queries in MySQL: Delayed Join and Bookmark Techniques

Youzan Coder

Nov 16, 2018 · Databases

Optimizing Large-Scale Pagination Queries in MySQL

When paginating millions of rows in MySQL, avoid large OFFSET scans by using delayed joins or bookmark techniques that first fetch primary‑key values via covering indexes, then retrieve the needed rows, dramatically reducing I/O and query latency.

bookmark paginationdatabasedelayed join

0 likes · 10 min read

Optimizing Large-Scale Pagination Queries in MySQL