Over memory? But when I have too many processes it kswapd tends to take over cpu...but not much swapping happening -- could it be its cleaning up garbage?
We're getting OT here, but I'll throw in my hunch anyway.
My hunch is that the problem is not an OS problem or even a DB problem. The problem is a badly designed application - probably written in Delphi or VB, but JBoss with stupid EJBs is also a candidate - that is treating a very large database table as if it were a small DBF file. The app loads *all* table records - probably thousands of them - whenever it needs to display a screenful of records. And there are several instances of this app running at the same time.
Rad
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.672 / Virus Database: 434 - Release Date: 4/28/2004
-- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
