Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2005-01-03 : 21:56:32
|
| just wondering is there any performance benefits for splitting up a complex after trigger?would it be better (on a performance basis only) to have 1 large after trigger compared to say 5 smaller ones?for simplicity in viewing i know splitting them up is easier just wondering if there are performance issues when you split up a large trigger into many smaller triggers |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-04 : 10:12:00
|
| You could test it, but I would think that firing 5 triggers compared to firing 1 would incur more overheadWhat's so complex about it?How many lines are we talking about?Brett8-) |
 |
|
|
|
|
|
splitting complex after trigger