Re: Database performance
Adam Aube wrote:
Christopher L. Everett wrote:
The problem is that these things often take 10 to 30 minutes to run on
my box. When I use the GNU time utility, I see a low PCPU number,
typically between 15 and 25%. CPU utilization viewed through top remains
at 35% or so, and I never go deeper than a few tens of kilobytes into
swap, even though the 1 minute load average climbs to 2 and higher (I've
seen peak numbers around 6).
Am I correct in thinking that the bottleneck lies in the HD subsystem?
So, what kind of hard drive subsystem can I run that would get me
3 to 4 times the performance that wouldn't break the bank?
Christopher L. Everett
Chief Technology Officer www.medbanner.com
MedBanner, Inc. www.physemp.com