offset pagination

Paging by saying how many items to skip, such as ?limit=2&offset=4.

In more detail

It is easy to read and debug, but when rows are inserted or deleted between requests, items shift between pages and can repeat or be skipped. Large offsets are also slow, because the database still reads and throws away every skipped row.

Example

GET /tasks?limit=2&offset=4

Related terms

Taught in

References