4 ms·
The problem I have with their eventual solution is that they only optimized their queries AFTER they had upgraded their instance to the largest config available
by canucker2016 3y ago
The problem I have with their eventual solution is that they only optimized their queries AFTER they had upgraded their instance to the largest config available.
They couldn't upgrade their config with a few clicks in the admin console anymore (I'm guessing what's involved here) so now they had to use actual grey matter to fix their capacity problem. Maybe if they had spent more time optimizing specific parts of their code, they wouldn't even need such a large config instance.
- sgarland 3y agoDespite the fact that SQL is not a complex language, and relational algebra isn't that hard, people regard it as dark magic. Administering and tuning RDBMS is dark magic. Doing basic query optimization should be viewed the same as "maybe don't write an O(n^3) algorithm."