Sunil

• Dec 9th, 2005

 

Main Purpose of Stored Procedure for reduse the network trafic and all  sql statement executing in cursor so speed too high.

Chandra

• Oct 5th, 2007

 

Stored procedure is precompiled SQL block. So it reduces the execution time.

sreyas kvm

 Profile Answers by sreyas kvm Questions by sreyas kvm

• Feb 9th, 2008

 

Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time

nithui

 Profile Answers by nithui Questions by nithui

• Mar 11th, 2009

 

1. It is used to increases the performance of the application. Because when
we create Store procedure, they are compiled and stored in database. Later when
applications call them, they are generally executed faster than the uncompiled
SQL statements which are sent from the database.

2. The network traffic between application server and database server is also
reduced. Because the applications don’t have to send such long and uncompiled
SQL Statements to the server to get the databack.

3. Reusability by multiple applications.