Post reply

Insert Speed

  • April 14, 2004 at 8:18 am

    #179171

    I'm running a DTS that on a daily basis takes 3 files.. 1 is used to delete records, 1 is used to update records and 1 is used to insert records.

    The update and delete files I bulk import into a database TEMPOR which is in simple recovery mode and then join against the main tables that are in a Full Recovery model database.

    The insert right now bulk imports directly into the fully logged database, right into the table.

    My question is, would I be better off importing the insert data into the TEMPOR db and then inserting from there into the main db, or leave it as it is?


    Shamless self promotion - read my blog http://sirsql.net

  • April 15, 2004 at 1:31 am

    #502855

    Bulk insert will request a lot of space in transaction log when using Full Recovery method. If your server's hardrive is limited, better to move the insert files' bulk insert to TEMPOR.

    It is only suggestion. Every methods have their pro and con!



    Regards,
    kokyan

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

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