keyset pagination
Continue a list after the last returned sort key.
Use this when Deep offset pages are slow or inserts shift the page boundaries.
without the term
“Page 500 of the feed takes forever, and when new posts come in, people see duplicates or skip items when they load the next page. Can you fix how paging works?”
with the term · How do you ask a model for keyset pagination?
Use keyset pagination for this feed with a stable tie-breaker. Verify no duplicate or skipped rows when timestamps match.
What is keyset pagination?
Keyset pagination uses an ordered cursor, often a timestamp plus a unique id, to select the next range.
Why does keyset pagination matter when vibe coding?
A cursor missing a tie-breaker can skip records with equal timestamps.
How do you do keyset pagination?
Define a stable ordering and matching index. Check repeated sort values and inserts between page loads.
What goes wrong with keyset pagination?
A changing sort field invalidates assumptions about traversal. Random page jumps may need another approach.