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?

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

Quote:

---

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?