April 29, 2010 at 3:27 am
You can also use Triggers for parallel insertion but it can slow down the Insert / update process. Using Service Broker can be helpful in this regard. Just initialize Service broker conversation in the trigger and SB will do the rest of the job.
April 29, 2010 at 5:26 am
Atif Sheikh (4/29/2010)
You can also use Triggers for parallel insertion but it can slow down the Insert / update process. Using Service Broker can be helpful in this regard. Just initialize Service broker conversation in the trigger and SB will do the rest of the job.
For 2000 rows a day? 1 row every 43 seconds?????
How's that ever gonna slow down a server and require an elaborate solution.
I do 20 K rows insert on my live server just to see the current log traces running on the server and it doesn't slow down ANYONE... even if I do that at 9 AM where it's the biggest rush hour for the server.
April 29, 2010 at 10:48 pm
For 2000 rows a day? 1 row every 43 seconds?????
How's that ever gonna slow down a server and require an elaborate solution.
You are right. But it is always to have multiple alternates in your pocket before going for such Bulk insertion process.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply