Re: Perfomance Tuning Help

Performance tuning can be a rather extensive topic, which is why you're being probed for specifics. For general tips, you can check the IIUG site or the performance tuning guide is available in PDF format at: http://www.informix.com/answers/ > In article <7ump5l$qod$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > From: zukracer@my-deja.com > > > > > >I am looking for some suggestions for enhancing the performance of > > >Informix for web based applications. > > > > What's the problem? > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com > > > The database has 42 tables of which 32 of them are linked together. > The application running queries against it makes multiple queries per > second and writes large blocks of information every 3 mins. Does Informix > manage tablespace growth efficiently or is it better to manage it > manually? How often should you re-index? Any suggestions for general > Informix performance tuning? I am really looking for general suggestions > for tuning this database. > > > Sent via Deja.com http://www.deja.com/ > Before you buy. >

Thanks! I will check there. In article <7uqglo$bfe$1@news.xmission.com>, "Chuck Renaud" <crenaud@informix.com> wrote: > > Performance tuning can be a rather extensive topic, which is why > you're being probed for specifics. > > For general tips, you can check the IIUG site or the performance > tuning guide is available in PDF format at: > > http://www.informix.com/answers/ > > > In article <7ump5l$qod$1@news.xmission.com>, > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > > > From: zukracer@my-deja.com > > > > > > > >I am looking for some suggestions for enhancing the performance of > > > >Informix for web based applications. > > > > > > What's the problem? > > > > > > ______________________________________________________ > > > Get Your Private, Free Email at http://www.hotmail.com > > > > > The database has 42 tables of which 32 of them are linked together. > > The application running queries against it makes multiple queries per > > second and writes large blocks of information every 3 mins. Does Informix > > manage tablespace growth efficiently or is it better to manage it > > manually? How often should you re-index? Any suggestions for general > > Informix performance tuning? I am really looking for general suggestions > > for tuning this database. > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > > > Sent via Deja.com http://www.deja.com/ Before you buy.