On Tue, Jul 22, 2003 at 05:33:37PM +0800, Winelfred G. Pasamba wrote: > the problem is the it slows down when one department does their > database reporting. the queries run for about 7 minutes hogging the > whole cpu. and other users (about 20) complain that the keystroke > responses get long at times.
Without upgrading, you can inspect the queries you're talking about and see how you can optimize it as is, or maybe if it's already optimized see how you can improve performance further with indexing. How you'll do this will depend on your RDBMS. This probably the best thing to do immediately. After inspecting your queries, do a database run and observe how the system slows down and see why. I'm guessing that it's possible you're either running out of available main memory, causing the system to thrash, or the database access is causing too much disk activity on its own (eg: thrashing also causes excessive disk activity, so...). If it's a main memory problem, consider adding more RAM. Plug in another 512MB and see how things go. If you have enough money and space on your motherboard, consider maxxing out your RAM bays (1GB? 2GB?). If it's an I/O system bottleneck, consider using RAID. With a decent hardware raid controller like 3ware, you can continue to use IDE hard drives and RAID-10 should provide a speed increase together with a certain level of protection against one or two hard drives crashing. You can also consider a change of filesystems. Perhaps you may want to consider XFS[1], for example, or maybe ReiserFS[2], both of which have equally good reviews as far as both performance and stability are concerned. --> Jijo [1] http://oss.sgi.com/projects/xfs [2] http://www.namesys.com -- Federico Sevilla III : http://jijo.free.net.ph : When we speak of free Network Administrator : The Leather Collection, Inc. : software we refer to GnuPG Key ID : 0x93B746BE : freedom, not price. -- 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
