Re: Checkpoint Duration....ODS 7.24...

MS CARLEEN C AVANT <cavant@safecen.navy.mil> kirjoitti artikkelissa <6pt3lg$j3m$1@news.xmission.com>... > > Does anyone have suggestions regarding the following: > > An application which accepts arguments from a user then formulates an sql > query and queries the database reporting back to screen or print, heavily > utilizes temp tables. Informix creates temp tables if it can't find a index for sorting. So, the major issue is to define right idexes for the mostly used queries and thus prevent Informix to create temp tables. > One particular temp table is built to accept the > largest possible number of arguments and builds a table with a rowsize of > 5040 bytes. What is happening is that temp space is exceeded causing the > application to abort or flushing at checkpoint time causes what are > normally 0-1 second checkpoints to become up to 731 seconds. The temp > table is not being logged. > From a DBA perspective, how can the environment be tuned to handle this > sort of processing yet decrease the checkpoint duration to minimize the > performance impact currently being experienced at the times when this > application is running? > Feedback would be greatly appreciated. First thing is to check your database schema. Can you create denormalized tables for the query purposes? After this you should put efforts on $ONCOMFIG file Best regerds, Olli