#performance

5 posts
Development

Eleven Seconds to Eighty Milliseconds: Reading MySQL EXPLAIN Like a Pro

It's 2 a.m. and your phone is buzzing. The order dashboard, which loaded in 80 milliseconds last spring, now takes eleven seconds. Nothing in the code changed. What changed is the table: it went from...

2026.10.23 · 17 min read · views 466
Eleven Seconds to Eighty Milliseconds: Reading MySQL EXPLAIN Like a Pro
Development

Your Dashboard Took Eleven Seconds to Load. An Index Could Fix That.

It's a Tuesday afternoon, and the dashboard that loaded instantly during your first month of launch now takes eleven seconds. Nothing in the code changed. The table just grew from 5,000 rows to 4 mill...

2026.10.04 · 8 min read · views 854
Your Dashboard Took Eleven Seconds to Load. An Index Could Fix That.
Development

The Query Was Fine at 10,000 Rows

You wrote the query in an afternoon. It ran against your development database in four milliseconds, the test suite went green, and you shipped it. Six weeks later, someone in support forwards a screen...

2026.09.01 · 21 min read · views 1,686
The Query Was Fine at 10,000 Rows
Development

The Query Was Fine Until the Table Hit a Million Rows

Your app was fast for a year. Nothing changed — same code, same server, same query you wrote in an afternoon and never thought about again. Then one Tuesday the orders page takes eleven seconds to loa...

2026.08.22 · 18 min read · views 1,457
The Query Was Fine Until the Table Hit a Million Rows
Development

O(n²) Worked on Your Laptop. Then Real Users Showed Up.

You wrote a function that worked perfectly on your laptop. It flew through a list of 50 names, sorted them, found the duplicates, and returned an answer in a blink. Then you shipped it, real users sho...

2026.08.14 · 15 min read · views 2,462
O(n²) Worked on Your Laptop. Then Real Users Showed Up.
AD