Informix perf problem

} } ----- Transcript of session follows ----- } 550 wlyle@PROBLEM_WITH_INEWS_DOMAIN_FILE... Host unknown } } } > } > I have setup an informix database on a Sparc10. 5.00.UC3. The } > configuration is generally the same as other servers I have but it runs } > different applications. I have noticed that this server generally has } > 0% - 30% cache reads and 80% - 95% cache writes. On the other servers } > the cache read and write range from the high 80% to 90+%. Is it possible } > that the applicationbs software is negatively impacting the cache %?? } > } > The database is spread across 5 disks over two controllers. It is } > mirrored and has buffered logging. The configuration is listed below. Any } > ideas would be greatly appreciated. } > } } It's quite possible that the application is reading new data all the time } and can hence not take advatnage of buffering which is the big Online selling } point. On the other hand your buffers parameter is a bit low - especially } considering the size of some of the other things in there. Try doubling your } buffers and see what happens. } } j. } } merry christmas. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "Grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to hide the bodies of the people that I had to kill because they pissed me off." _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________