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

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

From: Eric <emfortin_at_comcast.net>
Date: Mon, 18 Oct 2004 11:56:01 GMT
Message-ID: <lbOcd.385258$mD.320872@attbi_s02>


One option is to use ODP.net (get it from Oracle's web site). With this, you could create an array of all your data, and then pass that array to an oracle stored proc that inserts the data

It will be 90+ % faster than doing your own inserts...

"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 - 06:56:01 CDT

Original text of this message

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