Re: Searches get slow after a while.

{Raj writes about his RS6000...} } } } Fellow Informix'ers, } } We have a database server application using Informix 5.0 Online } on an IBM RS6000 340. When the application comes up, the response time is } good, but we see a deterioration after a while. Searches seem to slow down } and the CPU usage seems to go to 100% (sar report). Restarting the applicatio n } does not seem to help. We need to reboot the machine completely to regain } speed. } } Could someone point out what seems to be the problem? This machine } is configured with 64MB of memory and has paging space in excess of 128M. } Are there any other tests/utilities I could run to get a clearer picture } of what is going on? } } Any and all responses greatly appreciated. } } Thanx, } } Raj. } -- } ============================================================================= == } __ __ . } / __/ / Raj Malhotra. } / ( /_ / voice : } __/ email : manmetha@gauss.rutgers.ed u } } ============================================================================= == Raj, We also have online 5.0 on a RS/6000 with 64MB of memory. As with you, we also experienced the extact same problems of speed deterioration. Even though in theory your paging space is correct, being twice that of the physical memory, for whatever the reason it is still not enough on the RS6000. We set our paging space to 200MG and that caused our mysterious speed slow downs to disappear. Hope that helps! ------------------------------------------------------- James Tibbets Application Engineer Rankin Technology Group 2432 W. Peoria Ave Suite #1286 Phoenix, Arizona 85029 -------------------------------------------------------