Re: Bulk loading an Informix database

Posted in 1994

Michael T. Reed — Mon, 25 Apr 1994 01:05:18 GMT — source: Informix-list mailing list archive (1991-1998)

mark@houston.com.hk wrote: : IF> I am trying to find a way to bulk load an Informix database. Is there : IF>a preferred method to do this (short of inserting each row)? We wrote our own "loader" using esql-c that does alot more than dbload or load. It even will do EBCDIC to ASCII conversion of selected columns. We have found it to be at least twice as fast as dbload or load because of the buffering used within the program. We can load 12,000 128 byte rows per minute (last benchmark on a Sun 690MP although we have a SC2000 now and I'm sure it's faster).