39 long-form articles on production engineering — how real systems fail, why, and what actually fixed them.
Schema design, query optimization, storage engines, and picking the right database.
8 articles in Query Optimization
Query Optimization13 min read
“We sold 3 tickets but only had 1.” The code is inside a transaction, looks right, works a hundred times locally, and only breaks in production under load.
Query Optimization13 min read
Every list endpoint ends in LIMIT 20 OFFSET ?. It has an index, page one returns in 8ms, and it passes review — then one Tuesday page 4,000 takes four seconds and a nightly export job stops finishing.
Query Optimization15 min read
We're trained to demand our data structures be correct — so here's one that's wrong on purpose, and runs inside Cassandra, RocksDB, Bigtable, most CDNs, and your browser's malware check.
Query Optimization18 min read
Every team ships with the same lie: throw everything on the database and it'll handle correctness. Works at 50 writes/sec.
Performance14 min read
Why your connection pool config is probably wrong — and how to fix it with Little's Law, Kingman's Formula, and the process-to-core ratio.
Query Optimization18 min read
A deep-dive into non-SARGable SQL with B-tree diagrams, real EXPLAIN output, and the exact rewrites — told through a gaming dashboard that went from 4,200ms to 2ms without touching the schema.
Query Optimization13 min read
How similarity search works under the hood — and why naive brute-force collapses at scale.
Query Optimization5 min read
What happens when your index outgrows your data — and how we fixed it without downtime in production.