dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: Bulk data insert

  1. #1
    Join Date
    Mar 2010
    Posts
    1

    Bulk data insert

    I have a resultset of 20500 records for which i need to insert data. It is taking 1 hr 35 minutes to insert this data in a loop. I need to improve performance for this. I tried dividing the count into chunks of arrays and it could reduce 20 minutes for me. Can you any one help me out with this issue?

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Bulk data insert

    Use a Database. Then, you can do Bulk Insert() of records, almost instantly.

    The db takes care of all the work. You just feed it the SQL code
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    Feb 2008
    Location
    Bangalore
    Posts
    149

    Re: Bulk data insert

    Quote Originally Posted by Nivs View Post
    I have a resultset of 20500 records for which i need to insert data. It is taking 1 hr 35 minutes to insert this data in a loop. I need to improve performance for this. I tried dividing the count into chunks of arrays and it could reduce 20 minutes for me. Can you any one help me out with this issue?
    Which database you are using? What is the source of resultset?
    Encourage the efforts of fellow members by rating

    Lets not Spoon Feed and create pool of lazy programmers

    - ComIT Solutions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)