Re: help dbload or LOAD which is faster?

Posted in 1996

"Malcolm Weallans" — Thu, 14 Mar 1996 23:35:09 GMT — source: Informix-list mailing list archive (1991-1998)

> > > > I'm going to be load a large amount of data to either Informix SE or > > Online 7.1. I'm concerned about the run time. Is the dbload utility > > faster or slower than SQL LOAD or doesn't it matter. Indexes, if any, > > won't be built until after the load. > > > > On our development box dbload runs at about 100MB/HR. LOAD at about > 200MB/HR.An INSERT cursor runs at about 400MB/HR - the trick there is > using 'c' todo the string manipulation (using pointers vs. passing nasty > strings about). > > cheers > j. > ________________________________________________________________________ > _____Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA > jparker@hpbs3645.boi.hp.com But, Jack, speed is not everything. DBLOAD is transaction aware, but LOAD is not! Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc