Improving BCP speed apart from dropping indexes

  • Anyone know how BCP speed can be improved apart from dropping indexes on the table ?

    Database is in a simple recovery model, does this actually do any good ?

    Looking forward to hear from you all

     


    Kindest Regards,

    John Burchel (Trainee Developer)

  • You can set your batch size. This will sometimes speed things up.

    Tom

  • 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.

  • 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

  • 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