medium10 pts · first answer countsapi-designsqlperformance

Offset or cursor pagination

An activity feed with millions of rows uses LIMIT 20 OFFSET 200000. Pages get slow and users sometimes see duplicate items when new rows are added. What is the better approach?

A.Increase the page size to 1000 so fewer pages are neededB.Use cursor (keyset) pagination, e.g. WHERE id < :last_seen_id ORDER BY id DESC LIMIT 20C.Cache every page forever in RedisD.Use SELECT COUNT(*) before each page to fix the duplicates

← Isolation levels and dirty reads Token bucket rate limiter →