---
answer: direct
beat: backend-engineering
source: 1 article · updated: November 15, 2026
---

Why is cursor-based pagination superior to offset-and-limit pagination?

Offset pagination (OFFSET 100000) forces the database to read and discard 100,000 index entries, creating severe performance degradation. Furthermore, concurrent row insertions cause offset drift where items are skipped or duplicated. Cursor pagination uses index range scans (WHERE id > cursor) in constant O(log N) time.

Answered in

Modern REST API Design: Noun-Based Resources, Idempotency Keys, Cursor Pagination, and Security Hardening

An architectural guide to designing production REST APIs: idempotent mutations, cursor pagination, status code precision, and zero-trust security.

Crashtech Editorial November 15, 2026 Backend Engineering

Read the full analysis

Other questions this article answers

More backend engineering questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the Backend Engineering beat.