help dbload or LOAD which is faster?

> > 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' to do 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 _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________