Re: Perfomance Tuning Help

Posted in 1999

Obnoxio The Clown — Thu, 21 Oct 1999 10:39:44 BST — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Obnoxio The Clown

zukracer@my-deja.com — Thu, 21 Oct 1999 21:44:08 GMT — source: Informix-list mailing list archive (1991-1998)

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.