Arguments for/against Business Logic in stored procedures -


What are the logic for commercial reasoning in stored procedures and against it?

Against stored procedures: trading logic in programming space

I have a high value on the power of expression, and I do not think of SQL space that all are expressive. Use the best tool for the most suitable tasks, the best of the addictive at the highest level with logic and high order concepts. Consequently, storage and mass data manipulation is done at the best server level, perhaps in stored procedures.

But it depends. If you have many applications to interact with a storage system and you want to make sure that it maintains its integrity and workflow, you should offload all the logic of the database or manage the concurrent development in multiple applications. Be ready for


Comments