SQL load or DBLOAD

Posted in 1998

Carlson@WHSmith — Tue, 23 Jun 1998 17:02:03 GMT — source: Informix-list mailing list archive (1991-1998)

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 . . 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???? TIA John Carlson Informix DBA WH Smith, Inc.