api-designbackenddatabases
Offset or cursor pagination?
Anonymous
Offset pagination is simple, but large offsets can require skipping many rows, and inserts between requests can shift page boundaries. Cursor pagination uses an ordered key to continue from a known position; include a unique tie-breaker when the main sort key can repeat.
0