Searches get slow after a while. Any fixes or workarounds?
Posted in 1994
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 application 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.edu ===============================================================================