Post reply

Improving BCP speed apart from dropping indexes

  • July 5, 2006 at 3:21 am

    #61415

    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)

  • July 5, 2006 at 1:08 pm

    #647600

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

    Tom

  • July 6, 2006 at 7:17 am

    #647741

    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

    #647946

    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

    #649560

    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