TechPlanetScaleabout 3 years ago
Pagination in MySQL
19 min read
MySQL pagination uses offset/limit or cursors to select only needed rows. Deterministic ordering is required for consistent results. Non-unique sort columns allow MySQL to choose row order, causing potential inconsistencies across queries.
Level
Hype check
Tap to vote and see what everyone thinks.