Re: Preformance Problems URGENT with V.7

Arjo Snijder wrote: > > Whe have big problems while saving records to the infomix database, it takes > between the 20 en 40 second before a record has been saved. > > Whe use informix version 7 How about more details, like: o Exact IDS version as in 7.31UC2-2 or some such. o Hardware platform and OS versions. o ONCONFIG file. o Table schema (dbschema output) for the offending table(s). o Is the "saving" an update or insert? o What is the UPDATE STATISTICS level of the table? Are there distributions? o How are you timing/testing this (ESQL/4GL/dbaccess)? Art S. Kagel