Re: ADO&Oracle bulk inserts ( what else! )

"JohnP" <johnp_at_optonline.net> wrote:

>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
>

Cross-posting is not good practice..

Why not create a SP that handles the real work ad use ADO's command object to execute it? Received on Wed Oct 20 2004 - 11:47:01 CDT