medium10 pts · first answer countsquery-tuningindexing
Slow deep pagination
An API pages through 50 million events with ORDER BY id LIMIT 50 OFFSET n. Page 1 is fast but page 100000 is slow. What is the best fix?
Discussion 0
Join free to post in the discussion.
Related questions
- When a B-tree index helpsDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- Composite index column orderDatabase Administrator
- Reading an EXPLAIN ANALYZE planDatabase Administrator
- Covering indexDatabase Administrator
- Which query to tune firstDatabase Administrator
- Adding an index on a live tableDatabase Administrator
- Sort Method: external mergeDatabase Administrator