which is the fastest way Triggers, Services, Procedures in Jobs or Agent?
Hi i am using SQL SERVER 2008 R2,
i am new in performance and tuning where i am working on how to improve the performance of an product. 
so i have to right the business logic for product and will be implemented.
so following are the option by that we can implement it.

1] Triggers
2] Services
3] Procedures in Jobs or Agent

from the above which one is the fastest way to implement so that it wont take for the front end to take a load, and to retrieve the data and get available to the front end or is there any other option by which we can implement the business logic.
Thanks! in advanced. 

which is the fastest way Triggers, Services, Procedures in Jobs or Agent?
===

Hi i am using SQL SERVER 2008 R2,
i am new in performance and tuning where i am working on how to improve the performance of an product. 
so i have to right the business logic for product and will be implemented.
so following are the option by that we can implement it.

1] Triggers
2] Services
3] Procedures in Jobs or Agent

from the above which one is the fastest way to implement so that it wont take for the front end to take a load, and to retrieve the data and get available to the front end or is there any other option by which we can implement the business logic.
Thanks! in advanced. 
