Tag: Advantages and Disadvantages of Stored Procedure

Advantages: the Stored procedure can be used as modular programming – means create a once, store and call several times whenever required. This supports faster execution instead of executing multiple queries. This reduces network traffic and provides better security to the data.

Disadvantages: The disadvantage is that it can be executed only in the Database and utilizes more memory in the database server.