#MySQL

3 posts
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 437
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 679
The Query Was Fine Until the Table Hit a Million Rows
Development

The JOIN That Quietly Dropped Half Your Data

You wrote a query to list your customers and their orders. It ran fine — but half your customers vanished from the results. The ones who never placed an order simply weren't there. Nothing errored, no...

2026.08.12 · 15 min read · views 1,111
The JOIN That Quietly Dropped Half Your Data
AD