Multiple ChoiceIntermediate 45s
Stable Cursor Pagination
Why is cursor-based pagination preferred over OFFSET pagination for a fast-moving feed?
Options
- 1A cursor anchored to a stable sort key avoids skips and duplicates when items are inserted between page fetches
- 2Cursors require far less network bandwidth to transmit than plain integer offsets do on every page fetch
- 3OFFSET-based pagination cannot be indexed at all and therefore forces a full scan during every fetch
- 4Cursors eliminate the need to define any stable sort order on the underlying feed at query time
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.