ADO&Oracle bulk inserts ( what else! )

I need to write an ado app that reads a 27million record table, process it and insert it into a new table.
Unfortunately I have no choice on the use of ADO.

My question is, on the inserts am I better off using a Command object and specify not to return any record sets. Or should I use the Recordset object and specify lockbatchoptimistic?

I know I should check to see if the 0040 driver/interface is being used.

Also, for the reads and writes should I use client side or server side cursors. I really do not need any transaction processing. The table will not be accessed during the process.

So far it seems that writing the data to a text file and then using the bulk insert utility( or whatever it is called) is the fastest but again that is not desired by others.

So any feed back is greatly appreciated

johnp Received on Mon Oct 18 2004 - 05:30:57 CDT