3 ms·
The argument is not that you should use application code where SQL is more efficient. The argument is that the sql shouldn’t be in the database itself as store
by scarface74 4y ago
The argument is not that you should use application code where SQL is more efficient. The argument is that the sql shouldn’t be in the database itself as stored procedures separate from your application code.
- jasfi 4y agoOnly DB portability would be a concern to not used stored procedures, that I can think of. If you want to write an application that can use multiple DBs then you might have a problem.
- scarface74 4y agoEven if you don’t use stored procedures, simple stuff like how you limit the return results is different between databases like SQL Server and MySQL as is how you do bulk inserts. How you specify locks, the support data types, casting, intrinsic functions, conditional statements (case functions) are all different between databases.
- jasfi 4y agoORMs can abstract most things, but not stored procedures.