July 5, 2006 at 3:21 am
July 5, 2006 at 1:08 pm
You can set your batch size. This will sometimes speed things up.
Tom
July 6, 2006 at 7:17 am
Setting it large or setting it small?
We're encountering a similar problem, a bulk copy operation is taking far longer than anticipated, and we're looking for tuning ideas.
July 7, 2006 at 6:30 am
I would test what size it should be set at. Batch size controls commit actions. If you're bcp'ing 1,000,000 wide rows and your constantly waiting for your log file to grow, then a smaller batch size should speed things up. Indexes and constraint checking make a big difference in speed also.
Tom
July 17, 2006 at 8:05 am
put your DB to bulk logged mode instead of simple. This will reduce the number of entries into the log
Bye
Gabor
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply