July 29, 2008 at 5:18 am
We are loading about 1.8 million records from a flatfile. what should be the commit interval for loading this?
[font="Comic Sans MS"]--
Sabya[/font]
July 29, 2008 at 5:22 am
sabyasachi.mukherjee (7/29/2008)
We are loading about 1.8 million records from a flatfile. what should be the commit interval for loading this?
Depend on: what recovery mode you are using (you may want to switch to bulk during the load), how large the rows are, are you expecting any conflicts/ roolbacks, in case of rollbacks how much you would like to roll back, what is the size of your transaction log, how much it is growing, are you happy with the growth rate, is this happening during a busy/quiet period, ...
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply