Re: How to speedup sqlldr

From: <chiappa_at_my-deja.com>
Date: Mon, 02 Oct 2000 11:47:58 GMT
Message-ID: <8r9sle$dhe$1@nnrp1.deja.com>

In article <39D6CE81.504D5FA1_at_hccnet.nl>, Johan den Boer <jj.den.boer_at_hccnet.nl> wrote:
> Hi,
>
> I have to load about 400 files into a database. Some files are
> really big. The default for sqlldr is to commit every 64 records.
> Is there a way to change this behaviour in say 256 or 1024 record ?
>

yes, you can do this altering the buffer load sizes, but in many cases the most time-consuming operations are index and log file related. So, I recommend to use the DIRECT PATH option with UNRECOVERABLE(and some people prefer just disable the indexes and archive options and to rebuild the indexes later, if possible). See the "Server utilities manual", in the sqlloader chapter.

[]s

Chiappa

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 02 2000 - 06:47:58 CDT