Re: fastest way to insert/update i million rows

> I have a need to update about 1 million rows of a table and insert
> another million rows into two other tables. I am constrained by the time
> to be able to perform all the above operations of about 12 hours.
> Therefore I need the fastest means to do this.
>
> I have the following ideas:
>
> 1. Use sqlloader for inserts
> Pro-c/c++ host arrays to update the records.
>

IMHO, this method will be the fastest.

> 2. Write a PLSQL function to insert and update the records and then call
> it using Pro-c/c++ code using host arrays.
>
> 3. Write a perl script to generate all the insert and update SQL
> statements into a ascii file and then use sqlplus to process the
> ascii files.
>
>
> 2. Can disabling the constraints increase the speed of updates?
> If yes, how complex is the process of enabling the constraints
> back again ? ( I am sure that there will be no other process
> updating the data and my updates do not violate integrity of
> the data.)

Yes, you can and this is very good idea. Received on Thu Sep 02 1999 - 09:44:19 CDT