Re: SQL load or DBLOAD

Hi Carlson, 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 . . The LOAD command from dbaccess tries to insert the data into the table in a single transaction and will use an insert cursor. With DBLOAD you can split the load job into several transactions. DBLOAD will use an insert cursor, too. Although it's often possible to turn off transaction logging during load jobs, I would recommend DBLOAD. > BTW: I've seen the new loader . . . but I haven't found a > character-based mode for setup. Is it there, or is it GUI only???? The loader itself just needs the database entries, but I just saw a GUI to fill the database. Bye Stefan Weideneder