top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Advantage of using stored procedures?

0 votes
Advantage of using stored procedures?
posted Aug 11, 2014 by Vrije Mani Upadhyay

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

It helps you to build powerful database applications, stored procedures provide several advantages including better performance, higher productivity, ease of use, and increased scalability.


answer Aug 12, 2014 by Pankaj Deshmukh
0 votes

Here are some :

  • Stored Procedures are compiled and stored in executable form and that's why procedure calls are quick and efficient.
  • Provides a "public interface" to a database (another abstraction layer).
    Also groups all queries at the same location, making it easier for DBAs to see how the database is queried and optimize it accordingly.
  • By using SPs, you also avoid having to give users direct access to tables. All access can be controlled via the SPs
  • Another advantage to using stored procedures, especially in medium to large scale web sites or applications, is the data functionality is separated from the application making it easier to manage, document, and maintain. For example, if an application updates the customer table in ten different places, there can be a single stored procedure and a standard procedure call from the application for this functionality. If a change needs to be made to the way a customer record is managed, then the SQL statements only need to be changed in one place, in the database layer
answer Aug 16, 2014 by anonymous