3 ms·
Without knowing much detail about your platform or what it does, you should be using the database to be doing the heavy processing, it is likely to be more effi
by collyw 11y ago
Without knowing much detail about your platform or what it does, you should be using the database to be doing the heavy processing, it is likely to be more efficient than application level code. In my opinion the declarative nature of SQL means that is less buggy than application code (though that may not always be the case).
I usually find if my application code is getting to complex is time to update the data model.
Is the database properly indexed so that the queries run optimally? If you aren't sure, this site here is an excellent resource. http://use-the-index-luke.com/ http://use-the-index-luke.com/