Re: LOADING DATA INTO WAREHOUSING
Have you tried dropping any indexes on the table and re-creating them after
the load, followed by update statistics?
---------------------- Forwarded by Rajesh Kapur/CBSI/Spartan on 09/11/98
01:18 PM ---------------------------
"Art S. Kagel" <kagel@bloomberg.net> on 09/10/98 04:51:40 PM
Please respond to kagel@bloomberg.net
To: informix-list@iiug.org
cc: (bcc: Rajesh Kapur/CBSI/Spartan)
Subject: Re: LOADING DATA INTO WAREHOUSING
BEATRIZ ROCHA wrote:
>
> We have an ASCII file that is currently 4GB that has to be loaded into an
> Informix table. The load command
> takes about 8 hours. I have added a few things to speed up the load such
> as locking the table.
>
> Is dbload faster than load?
Dbload is about the same as the DBACCESS LOAD command and faster than
the LOAD library command in 4GL. The main advantage of dbload is that
it commits every N rows and logs errors, optionally without stopping.
With dbload you will use fewer locks and less logspace avoiding long
transaction rollbacks.
Art S. Kagel