Re: help dbload or LOAD which is faster?

Posted in 1996

Billy Wheeler — 13 Mar 1996 07:13:10 -0500 — source: Informix-list mailing list archive (1991-1998)

At 01:09 AM 3/13/96 -0500, Blubottle wrote: >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. Neddie Seagoon says: 1. If the database is unlogged, LOAD should be quicker. 2. DBLOAD is far more flexible interms of handling failed records, commiting after a certain number of records, etc. FWIW, I generally use DBLOAD. -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 "Have you got it yet?" (c) Kitsch 'n' Sync Productions 1996 -----------------------------------------------------------------------------