Re: how to speed up SE and DS

On 11 Dec 98, at 8:53, Andre Koppel wrote: > 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. Well, I don't have any useful ones, but how about: 1. Have you got too many indexes on the table you're writing into? 2. Are you running UPDATE STATISTICS often? 3. What logging mode are you running? 4. Has your server been tuned? The FAQ is somewhere in the mists of http://www.iiug.org HTH. -- Ciao, Billy "You don't win a war by dying for your country. You win a war by making the other son-of-a-bitch die for his." - General Patton