| Author: purushothaman 28 Aug 2008 | Member Level: Gold | Rating:  Points: 5 |
hi
-->we can write more flexibility conditional logic
-->excution time reduced because stored procedure is within the database
-->Stored procedures reduce network traffic and improve performance
-->Stored procedures are pre-compiled so excution plan time is quick
see this link
http://databases.about.com/od/sqlserver/a/storedprocedure.htm
http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
|
| Author: D.Jeya kumar(JK) 28 Aug 2008 | Member Level: Diamond | Rating: Points: 4 |
Hi,
Stored procedure is pre compiled one and it will execute faster than query
It can called one time and we can execute many sql statements in a single Stored procedure.
Stored procedure will reduce network traffic
Regards
JK
|
| Author: http://venkattechnicalblog.blogspot.com/ 31 Aug 2008 | Member Level: Diamond | Rating: Points: 3 |
Stored Procedures are precompiled one and it will increase the performance of your application.
Regards,
Venkatesan prabu .J
http://venkattechnicalblog.blogspot.com/
|