Post reply

Performanence Issue

  • February 10, 2011 at 7:20 am

    #149891

    Hi,

    I have inserted data through tool into sql server 2005.

    If commit is made every 1000 records, the 1399 record is getting loaded at 45 Min

    Please help me..

    It taken to long time (45 min)

  • February 10, 2011 at 12:04 pm

    #1285410

    Based on the rather vague description I expect you insert the data row by row.

    If that's the case, change your insert concept to use a single insert for all 1399 rows.

    It seems like you're using the wrong "tool" or using the right tool the wrong way. Hard to tell...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 10, 2011 at 12:14 pm

    #1285415

    Tool? What tool? What is your question?

    __________________________
    Allzu viel ist ungesund...

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

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