Re: Dbload performance

Rob McAllister (rmcall@on-ramp.ior.com) wrote: : 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. I do exactly the same thing to do a 17M row import from a 1.7G ascii flat file. Using nawk to do some very minor conversions, I write my output to a named pipe and then have dbload read from that named pipe. I've been able to get between 550-600 rows into my database per second. The ASCII rows are about 144 bytes each. The platform is a Pyramid MIS-4S running Informix v7.01. This seems pretty quick to me . . . -- +----------------+-------------------------+---------------------------------+ | Michael Faurot | mfaurot@phzzzt.atww.org | I programmed COBOL in college. | | ------- ------ | ------- ------ ---- --- | But I never compiled . . . :-) | +----------------+-------------------------+---------------------------------+