2 ms·
Moving 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.
by ako 9y ago
Moving 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.