3 ms·
> This sounds like an old-wives tail at this point. Except it's not. I've seen it in person, over and over. I've gone into systems where people were complainin
by matwood 8y ago
> This sounds like an old-wives tail at this point.
Except it's not. I've seen it in person, over and over. I've gone into systems where people were complaining about the 'database is slow', but there were no indexes. I've seen systems pull back 100s of thousands of records and then sort on app server and take the first 50. I've seen what would have been a simple join with exists clause turned into many round trips to the db with loops and app code complexities where a query would have 100x easier to reason about.
It's not even about optimization yet, but taking the time to learn even the surface capabilities of the tool.
- deleted 8y ago[deleted]