Performance Tuning Tip #2 – Process Data In The “Right” Layer
Tip 2: Process Data In The “Right” Layer
I find that it is almost always faster to process data within the DBMS rather than sending the raw result set back to the application layer and iterating / processing each row individually. A DBMS is specifically designed to handle sets of data. Do as much of the processing in the DBMS before returning the result set to the application layer. You may be able to do the processing in another layer, but ask yourself “Is it the most appropriate?”
