This is much more efficient than sending entire SQL statements over the network, especially if there are many users performing the same actions. Let's say we have a table called orders. When deciding to use stored procedures you can follow the rules below. Stored procedures execute by simply passing an execute command to the database. This relieves the network from having to pass an entire SQL statement over thus saving bandwidth and response time.
Stored procedures are precompiled.
Thus all error checking is done at the time it is built. This ensures solid SQL Statements and fast execution time. Stored procedures are fantastic for maintaining data integrity. Good data integrity always translates into good response times. Triggers Triggers are very similar to stored procedures in that they also reside in the database itself.