Tag archive

#pagination

Topic-specific entry points for internal linking, discovery, and deeper subject exploration.

2 articles

Pagination at Scale: Keyset vs Offset

Pagination at Scale Pagination looks simple until your table has tens of millions of rows, users sort by multiple fields, and product asks for infinite scroll with strict latency SLOs. Many APIs start with LIMIT ... OFFS…

Apr 20, 20265 min read

Comparison

#api-design#pagination#performance

System DesignIntermediate

API Pagination at Scale: Why OFFSET 100,000 is a Database Killer

API Pagination at Scale: Moving Beyond OFFSET Designing a paginated API seems simple: just use LIMIT 20 OFFSET 100. This works perfectly for the first few pages. However, once your users reach page 5,000, your database p…

Apr 20, 20262 min read

Deep DiveBackend Systems Mastery

#api-design#pagination#sql