how to speed up SE and DS

Posted in 1998

Andre Koppel — 11 Dec 1998 08:53:04 GMT — source: Informix-list mailing list archive (1991-1998)

I have written an application, that manages a great INFORMIX-database with several tables. I am using SE on a LINUX PII/400 for development, the production-computer is a SUN Enterprise 450 with INFORMIX-DS installed. This is my first application written in ESQL/C. I have found, that inserting a row into a table, that contains more than 10000 rows is very slow (on both SE and DS). Are there any genreral hints or a FAQ how to speed up the insertion? Some usefull hints are very appreciated. Regards Andre