Re: Database performance

[Adam Aube <aaube01@baker.edu>]

Christopher L. Everett wrote:

>>>Am I correct in thinking that the bottleneck lies in the HD subsystem?

>>Yes.

> 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?

Define "break the bank". The more money you're willing to sink into this,
the better performance you can get. A few options you can try:

1) Dedicate a second hard drive to the database files
2) Move from IDE disks to SCSI disks
3) Some form of RAID (preferably hardware)

Regarding RAID, I believe 0+1 gives the best performance, but it requires 4
disks. RAID 5 and 0 also will give a performance boost, and require at
least 3 and 2 disks, respectively.

You can price out the various options and see at what point it breaks the
bank for you.

Adam