Re: SQL load or DBLOAD

Carlson@WHSmith wrote: > Informix: 7.23.UC4 > OS: HPUX 10.01 > > I'm looking at a partial database reorg this weekend and started looking > at my reorg shell script. I need to shave a bit of time off this > process, as our data has grown considerably. Short of using the > High-Performance Loader (haven't had the opportunity to play with it > yet), which would be faster: > > load from "filename" > insert into table_name> > OR > > DBLOAD -d database -c configfile . . . etc . . [cutting] Personally I'd use dbload 'cos I believe it is more robust and easier to control. However, last time I asked ITS which was quicker I was told load was marginally quicker but only because of control. Depending on your existing and proposed layout there might be some mileage in investigating parallel loading from scripts. -- Paul Watson # WF Software Ltd # I don't suffer from stress - Tel: +44 1436 674729 # I'm a carrier. Fax: +44 1436 678693 # www.wfsoftware.co.uk #