Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ADO&Oracle bulk inserts ( what else! ) thanks to all

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

From: JohnP <johnp_at_optonline.net>
Date: Mon, 18 Oct 2004 21:19:53 GMT
Message-ID: <ZrWcd.6412$YM4.2367202@news4.srv.hcvlny.cv.net>


My boss finally agreed to use bulk inserts from text files, sanity!

"JohnP" <johnp_at_optonline.net> wrote in message news:BXMcd.3646$YM4.761411_at_news4.srv.hcvlny.cv.net...
> 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 - 16:19:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US