Re: What are the .... ?

Posted in 1996

"Malcolm Weallans" — Thu, 25 Jan 1996 17:24:41 GMT — source: Informix-list mailing list archive (1991-1998)

While I agree with the importance of the previous response, I would add that log sizes are pretty important as well. > In article <4e3llc$om8@cssun.mathcs.emory.edu>, > 1689@MN.LAWSON.lawson.com (Anjan Chakraborty) says:> > > > >Hello Friends, > >What are the key parameters to look for, tune etc. in case of an > INFORMIX >5.0 Server > >in an OLTP and Batch Insert,Update & Delete environment ? > >Any comment is welcome. > >Thanks. > >Anjan > > > Disk layout / organisation is usually the biggest factor. Know how > big your tables are likely to be and set your initial and next > extent sizes when you first build the database. If you can put > the busiest tables on different physical disks. Get the log files > out of the rootdbs into a quiet corner. Don't put tables in the > rootdbs.....The Informix Administrators manual has all this and > more and should be required reading :-) Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc