The slowest query is usually the one nobody looked at
By Jonah Whitfield · Latest note
When a screen feels slow, teams reach for a bigger server. Nine times in ten, the real cause is smaller and cheaper to fix.
Measure before you move anything
Start by timing the whole path, from the click to the paint. Write the numbers down. The slow part is rarely where you expected, and a bigger machine only hides it for a few months.
Fix the boring thing first
A missing index or a loop that asks the same question a thousand times is a small repair. Make that change, measure again and stop when the screen feels instant. Resist rewriting what was never the problem.