December 2, 2009 at 11:51 pm
Hello,
Did anyone using trigger will burden the performance?
Is that true or only mith?
December 3, 2009 at 8:52 am
A trigger will have some impact on performance as triggers do work, consume resources, and extend transactions. The amount of impact depends on the work being done in the trigger and how the trigger is coded.
One of the first questions asked when performance tuning inserts/updates/deletes is are the any triggers on the tables involved.
I wrote an article on DML Triggers[/url] that might help you.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply