Need to insert around 65000 records, pls help to improve performance

[Som76]

Hello Everyone,

I need to insert around 65000 records to my database.
Please help to improve performance.
Currently I am calling Insert for every record one by one.
65000 insert call is badly slow. The data is currently available in an array.

Thank you.

Kind Regards
Som

 

[BrainB]

You do not say exactly where the records are coming from or where they are going. Presumably you are using Access.

There are ways of importing records in bulk from other applications - the usual one being via a text file. .DBF is also a useful alternative because most applications can recognise and read/write in this format.

You say data is in array format. You may be able to put it into an Excel worksheet first before importing.





Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================