From: kennedy-downwithspammersfamily@attbi.net   
      
   "goldenorb82"  wrote in message   
   news: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   
      
   Use Oracle's OCI api and using bind variables do array insert.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)