I have been in several debates and have read several articles on whether to use Stored procedure. I came up with set of points one should ponder before writing a Stored Procedure.
Basically a stored procedure is -
- Set of SQL statements stored on the server and are pre-compiled.
- Takes in certain arguments and processes that code with those arguments at execution time
Points to ponder before we use Stored Procedure
1. Ease to scale database compared to application tier?
2. Ease to write and maintain?
3. Ease to debug
4. Need for specialized skill set
5. Performance gain
6. Reduction in traffic between application and database tier
7. Reusability & transparency
8. Security
No comments:
Post a Comment