Is there any other alternative Insted of using 1000+ tigger??
We need to start 1000+ process (Select Query) Parallely,
We are working no MS SQL Server 2008 and a table called tblStory. We have lots of triggers (arround 1000) right now whenever a new story comes, we want to all triggers will fired and do some appropriate entry in tblUser table. but All triggers will fired like sequencially so have any way like 20 or 1000 triggers will execute at same time. so we will save time because 1000 triggers will take arround 1.5 mins. Approximate we have to come lots of stories in a minutes.
Question is How or What the way execute the all triggers at same time when inserting the new story ?
I am working with MS SQL 2008
I have around 1000+ Triggers on a single table,
Do all trigger fire in parallel, when I insert a record in that table?
Because I have written some time log information and based on that I found that all triggers are executed Sequentially