Post reply

After Bulk Insert Taking Large time for Updation

  • December 18, 2007 at 10:23 pm

    #184835

    Hi

    I am uploading around 1200000 records using Bulk Insert.

    Before that I am truncating that table.

    And then I am doing some updations on this table.

    This updation some time takes around 1 min and some time takes more than 5 min.

    Procedures for Truncate,Bulk Insert,Updations are different.

    I am not getting whats happening.Plz help.

  • December 20, 2007 at 7:54 am

    #761764

    This could be because the Statistic on the table is not Updated. Maybe you should just Update the statisitics of the table before trying to do the update.

    -Roy

  • December 21, 2007 at 4:57 am

    #762056

    Do you have indexes on this table. Maybe they are getting reorganised by these updations.

    "Keep Trying"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply