Offset, Cursor, or Keyset: Choosing the Right API Pagination Pattern

Pagination is essential for APIs that return large datasets, as loading thousands of records at once causes slow responses and high memory usage. Offset pagination is the simplest method, using page numbers and row-skipping, but slows down significantly on large tables and can return inconsistent results when data changes. Cursor pagination improves performance and consistency by using an encoded pointer to the last seen item, though it does not support jumping to arbitrary pages. Keyset pagination similarly avoids row-scanning by filtering on raw column values, offering the best database efficiency but requiring the client to handle actual field values like IDs or timestamps. Each approach suits different use cases, with offset best for small datasets, cursor for real-time feeds, and keyset for high-performance, large-scale data retrieval.