MySQLIntermediateWhy does OFFSET pagination get slower on every page?
Page 1 takes 5 ms and page 5,000 takes 4 seconds. OFFSET reads and throws away every skipped row. Switch to keyset (cursor) pagination for constant-time pages.
#indexing#pagination#performance
Tanishk · 8 min