Backend & systems·API and interface design
you ask for page 400 and the database dutifully reads and discards the first eight thousand rows to get there.
Offset pagination
Also calledLIMIT OFFSET, page number pagination
Paginating with a row offset and a limit. It is trivially easy and supports arbitrary page jumps, which is why it is everywhere. It degrades linearly with depth, and rows inserted or deleted between requests shift the window, so clients can skip or repeat items.