Hacker News new | ask | show | jobs
by xpil 1152 days ago
Certain operations use fewer resources when performed in the RDBMS than when performed in the application code.

As your data grows significantly, you may encounter new bottlenecks, and for some of these you may need to move some of the logic from your application into the RDBMS (ergo: write an SQL function or a stored procedure or a trigger, etc.).