#MySQL

2 posts
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 504
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 847
The JOIN That Quietly Dropped Half Your Data
AD