SQL OFFSET is worse than keyset pagination
a year ago
- #database
- #pagination
- #performance
- Two methods for fetching next pages in database queries: offset and seek.
- Offset method numbers rows and filters to skip previous pages, supported by many databases.
- Seek method uses the last entry of the previous page to fetch following rows, offering better performance.
- Seek method requires a deterministic sort order for accurate results.
- Row values syntax can be used for seek method but is not widely supported.
- Performance comparison shows seek method scales better than offset method for deeper pages.