3 ms·
One problem with having logic in the DB is that it's much harder to scale if you need 10x more computing power.
by BurningFrog 9y ago
One problem with having logic in the DB is that it's much harder to scale if you need 10x more computing power.
- ckarmann 9y agoScaling is like optimization in general: not everything will need to be able to scale, and even if they will, they often do not need to scale yet.
- ako 9y agoMoving the definition of your sql from your app to the database doesn't impact scalability, as in both cases the database needs to perform the query.
- BurningFrog 9y agoWe're talking about stored procedures, which are executable code/business logic.
- ako 9y agoYes, and if all your stored procedure is doing is execute a query and return a cursor to the result set, it's using just as much database cpu as with a regular query.