Tag archive

#database-optimization

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

2 articles

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

DatabasesExpert

Query Optimization: The Hidden Cost of Cross-Shard Joins

Query Optimization: The Hidden Cost of Cross-Shard Joins In a sharded database, the "Scatter-Gather" query is the silent performance killer. When you perform a join on columns that aren't the shard key, your proxy has to…

Apr 20, 20261 min read

Deep DiveDatabase Sharding Mastery

#sharding#database-optimization#queries