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. They too are precompiled and have a very similar structure. Triggers execute automatically based on a particular action to a table. The answer - triggers can be used for anything from audit trails to data validation.