39 long-form articles on production engineering — how real systems fail, why, and what actually fixed them.
4 articles matching “Indexes”
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
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 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.
Schema Design12 min read
Why DELETE is the most expensive DML operation in a relational database — and why a simple UPDATE SET deleted_at = NOW() is 4-8x faster under concurrent load.