469,923 Members | 1,431 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

Fastest for Inserting into Oracle?

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
Jul 19 '05 #1
1 7563

"goldenorb82" <go*********@gmail.com> wrote in message
news:23**************************@posting.google.c om...
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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Raj Kotaru | last post: by
5 posts views Thread by Gaurav - http://www.gauravcreations.com | last post: by
5 posts views Thread by beersa | last post: by
1 post views Thread by goldenorb82 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.