Re: HELP:performance for loading data into table.

To speed up a little more :

Drop any indexes currently on the target table and then rebuild them using the
UNRECOVERABLE option.

Steve Phelan wrote in message
<36D925C3.1D5ACD1A_at_toneline.n-o-s-p-a-m.demon.co.uk>...
>I'd strongly suggest SQL loader. Use the 'direct' mode for maximum
>performance. Your million records could be inserted in a matter of
>minutes, though index builds will take longer. Have a good read of the
>Oracle utilities manual first to note the restrictions/impact of 'direct'
>mode. We use SQL Loader for loading 100's of millions of records into our
>databases without problems.
>
>Steve Phelan.
>
>Sihua Luo wrote:
>
>> Hi, All,
>> I have performance tuning to load bulk data (over million records
>> stored in a flat file) into table. Would you mind show me which of
>> following is best.
>> Method One: use Proc*C code to insert(update) data into table.
>> Method Two: use Sqlloader.
>> Any comment will be helpful to me. Thanks in Advance.
>>
>> Frank Luo.
>
Received on Mon Mar 01 1999 - 07:52:45 CST