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

Home -> Community -> Usenet -> comp.databases.oracle -> Fastest for Inserting into Oracle?

Fastest for Inserting into Oracle?

From: goldenorb82 <goldenorb82_at_gmail.com>
Date: 30 Jul 2004 10:26:08 -0700
Message-ID: <231354a1.0407300926.2a8e8478@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 Received on Fri Jul 30 2004 - 12:26:08 CDT

Original text of this message

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