|
-
March 11th, 2010, 01:49 AM
#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?
-
March 11th, 2010, 03:24 AM
#2
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
-
March 11th, 2010, 07:08 AM
#3
Re: Bulk data insert
 Originally Posted by Nivs
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
