← Quiz: Pagination and Sorting: all 10 questions
Quiz: Pagination and Sorting · Question 9 of 10
Why does OFFSET 100000 LIMIT 10 get slow?
Why does OFFSET 100000 LIMIT 10 get slow?
- A.The database still reads and discards the first 100,000 rows
- B.LIMIT is not supported on big tables
- C.Indexes are switched off for OFFSET
- D.The JSON becomes too large
Answer & explanation
Correct answer: The database still reads and discards the first 100,000 rows
Keyset pagination (WHERE id > last LIMIT 10) avoids walking past skipped rows.
Can you get the rest right without peeking?
Take the timed Quiz: Pagination and Sorting quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →