4 ms·
Another approach is to refactor mega-queries into smaller, component queries using SQL views that are then pieced together in another, simpler query. YRMV.
by dventimi 13y ago
Another approach is to refactor mega-queries into smaller, component queries using SQL views that are then pieced together in another, simpler query. YRMV.
- chris_wot 13y agoNot the worst approach, but they can be very hard to maintain. If the view has an error, then it can be hard to troubleshoot what is going on.