Re: Fastest for Inserting into Oracle?

"goldenorb82" <goldenorb82_at_gmail.com> wrote in message news:231354a1.0407300926.2a8e8478_at_posting.google.com...
> Hello,
> I am a .NET newbie and have been doing a lot of reading to answer my
> question, but i am guessing that it is so basic, there isn't a lot
> available out there. Here's my problem: I am creating an API written
> in C# that connects to the Oracle Database and reads/writes data. I
> have an array that contains the information that will be input into
> the 45 columns of the database. At some point I need to be able to
> insert maybe 5-6 thousand records at a time because one a time will be
> very slow since there should be nearly 60,000 records in the database.
> In my reading I have found the following methods to do a bulk insert:
>
> 1. Bulk Bind
> 2. Insert into Select *... (I know this doesn't make sense in my case)
> 3. Batch Insert
> 4. Insert DataSet
>
> Which (if any) would be fastest and most sensible for my situation? I
> have really don't know much about what any of these mean, but if i'm
> pointed in the right direction, that would be a great help.
>
> thank you

Use Oracle's OCI api and using bind variables do array insert. Jim Received on Sat Jul 31 2004 - 06:21:09 CEST