Advantages of using procedures. Reusability of code: The procedures provide us an ease in our code by making the set of instructions reusable. So, we need not write the same set of instructions again and again when required. Less usage of memory: The procedure is a subprogram which is stored in the memory only one. Disadvantages. Stored procedure languages are quite often vendor-specific. Switching to another vendor's database most likely requires rewriting any existing stored procedures. Stored procedure languages from different vendors have different levels of sophistication. In one example from a couple of days ago, I converted a stored procedure I was querying to a view and saw queries with quite specific WHERE clauses become more than 100x times faster because the DB could push the filter conditions down into the view's query. It could also plan the query as a whole faster, so even an unfiltered use sped up by 25%. • Since the stored procedures reside on the server, you can set tighter security restrictions. This saves more trusted permissions for the well-protected stored procedure themselves. • Because stored procedures are compiled and stored outside the client application, they can use more sensitive variables within the SQL syntax, such as Hi all, I would like to ask you a question about the field of health, advantages and disadvantages of stored procedure? I thank you for giving me Webastor - Programming Tips and Tricks. Welcome, Guest. Please Author Topic: Advantages and Disadvantages of Stored Procedure? (Read 140 times) Levi. 1; Newbie; Answer: The "headline" answer would be no networking implies faster execution. But this depends heavily on the db engine's implementation of stored procedures, and what the SP is actually doing. Also, the ability to do things like batch up large INSERTs and such things in client code but not in A stored procedure can be invoked by triggers, other stored procedures or applications such as Java, C#, PHP, etc. Advantages - Typically stored procedures help increase the performance of the applications. Once created, stored procedures are compiled and stored in the database. However MySQL implements the stored procedures slightly different.