Browse Teach Curate

Offset-Based Pagination

Paging with LIMIT/OFFSET: simple and supports jumping to page N, but the database must scan and discard all skipped rows, and concurrent inserts shift items across page boundaries.

Questions this Concept answers

Why is offset pagination so popular despite its cost?

jeremy Video

Fixing Slow SQL Pagination with an ORDER BY Index and Deterministic Ordering

Offset-based SQL pagination (LIMIT/OFFSET, or OFFSET … FETCH NEXT … ROWS ONLY) has two independent defects: a performance defect and a correctness defect. The performance defect arises because an ORD…