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

Programmer DD

May 26, 2019 · Databases

How to Speed Up Large‑Scale MySQL Pagination: Practical Tips & Benchmarks

This article explains why traditional MySQL pagination (ORDER BY … LIMIT N,M) becomes painfully slow on tens of millions of rows, analyzes the root causes, and presents concrete optimizations such as covering‑index delayed joins, bookmark‑based scans, and query rewrites that can cut execution time to a third of the original.

Bookmark Scancovering indexdelayed join

0 likes · 9 min read

How to Speed Up Large‑Scale MySQL Pagination: Practical Tips & Benchmarks

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