Re: Dbload performance

Posted in 1995

Rob McAllister — Thu, 23 Nov 1995 02:15:58 GMT — source: Informix-list mailing list archive (1991-1998)

1) Don't create indexes until AFTER dbload is finished. 2) Increase the number of rows in a transaction (see -n option for dbload). 3) Better than 2 is to turn off logging all together during the load. Mark Spears <pmspears@edge.net> wrote: >We are in the process of loading about 80Gb into an Informix db using 7.1 >Online on a Sun SparcServer 2000. And a long process it is! >We are using dbload going into non-indexed files. Our source files are >pieces of tables ftp'd from the mainframe. >Are there any tricks to making dbload go faster? Any help is much >appreciated.