Browse Teach Curate

Cursor-Based Pagination

Paging by an opaque pointer to the last-seen item (`WHERE key > cursor LIMIT n`) instead of a numeric offset — stable when rows are inserted or deleted mid-scroll and O(log n) with an index, at the cost of no random page access.

Questions this Concept answers

Why does keyset pagination cost the same on page 900 as on page 1?

jeremy Video

Choosing Between LIMIT OFFSET and Cursor Pagination in MySQL with Deterministic Ordering

MySQL offers two pagination strategies — LIMIT/OFFSET and cursor-based (keyset/token) pagination — and both presuppose deterministic ordering, meaning the ORDER BY key set uniquely identifies every r…