3 ms·
> Yes, or you can skip that part and do the tricky part in an actual programming language But then - you miss out the power of the query optimiser - you have
by okket 8y ago
> Yes, or you can skip that part and do the tricky part in an actual programming language
But then
- you miss out the power of the query optimiser
- you have to transfer a lot of unnecessary data
- have a harder time to enforce consistency
- have a harder time to enforce access rules / security
There are good reasons to do as much as possible in the database and not in a programming language in the backend or even worse, the frontend/browser.
- srean 8y agoI don't think that follows. Many of the optimizations you mention (for example the first two) may in fact be removing baggage that probably would not have been there in the first place.