Re: LOADING DATA INTO WAREHOUSING

On 3 Sep 98, at 0:59, Tim Schaefer wrote: > 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? > > No freakin' way! Whoa. In loading a large table, dbload can be significantly quicker. dbload can be set up to commit every n transactions, which can make a big difference. Most of the performance hit with LOAD seems to stem from handling a really long transaction. > Read the manuals! You should definitely not be loading a 4 GB file with > the standard loading programs such as dbload, or load. Use the HP loader, > and save yourself some time. Depending on your system of course, the load > shouldn't be taking 8 hours. This, I agree with. :-) -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________