2 ms·
> Sometimes I understand the problem perfectly well, but a single beautiful query is not performant enough. > It wouldn't improve performance, but it might imp
by bigato 10y ago
> Sometimes I understand the problem perfectly well, but a single beautiful query is not performant enough.
> It wouldn't improve performance, but it might improve readability without denigrating performance.
These two statements of yours are negating each other, unless people started using "performant" as synonymous for readable now.
- blowski 10y agoOK, a clarification. My first attempt at a query is readable but performance is terrible. I fix the performance problem, but the query is now much less readable. I use a CTE as a compromise between performance and readability.