|
|
stored procedure is not scalable
Unless you are developing a two tier system and you have the confidence that this system will not change the basic requirement, for example, the users will not increase, the maintaince job is very few, etc. In a word, if your system never face the scale problem you can use SP as much as you like.
But, in three tier system, when you need more database connection, and your overload on SP will increase, vertical scale with increase the CPU or MEM can relieve your DB server, but most of the time only horizontal scale is the suitable solution. Unfortunately the SP will be a headache for horizontal scale since SP and DB are tightly coupled |
|