Re: A Quick Method To Load Files

Posted in 1995

Lester Knutsen — 30 Aug 1995 16:23:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> I need to load a 250 MB database (SE) from ASCII files. > Using dbload is too slow even creating the indexes after the > load. Does an ESQL/C or 4GL program perform better?. I mean, > a program that can read ASCII files and insert the data. > The fastest way I have found to load data is write an ESQL/C program to do it. The next best and a bit easier is to convert the data to ASCII delimited with | seperating fields and use the SQL command load from ... This will be faster then dbload but you give up the error logging and a few other nice features of dbload. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # #############################################################################