Re: LOADING DATA INTO WAREHOUSING

Hi, I really like the high performance loader, its very fast. We load about 11GB per hour using the high performance loader. Its well worth the time to set up and learn. I have also used it on a NT machine with SCO's Xvision X server. Saves buying an X-workstation. Once you have built the load formats you can run everything from the command line or as we do in cron jobs. Regards - Lester 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? > > Has any one use the High Performance Loader. We do not have X windows, so > I have not been able to test the High Performance > Loader. If any one has used it, do you have some suggestions on how to > run-it through the command line. Is the HPL really > efficient. > > We will be moving to a bigger HP box with 1GB of memory and a good number > of processors, but for know I have to do something > with the current machine > > Any help will be greatly appreciated. > > Thanks > beatrice.rocha@worldnet.att.net -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Grant group privileges for Informix databases with DB Privileges Visit our Web page: www.advancedatatools.com Washington Area Informix User Group: www.iiug.org/~waiug/ ______________________________________________________________________