3 ms·
100% true. I wrote some very elegant, readable SQL to perform a complex query. It was dog slow. I handed it to a DBA, they ripped out the CTEs and replaced th
by TheCleric 4y ago
100% true.
I wrote some very elegant, readable SQL to perform a complex query. It was dog slow.
I handed it to a DBA, they ripped out the CTEs and replaced them all with temp tables. The query was an unreadable mess at the end, but boy was it orders of magnitude faster.
- recursive 4y agoBehold, the declarative 4th generational language.
- mwigdahl 4y agoDid they do something else other than just popping CTE queries into temp tables? In my experience, _just_ doing that doesn't affect readability much at all.
- TheCleric 4y agoNot that I recall, but I found it much less readable personally.