> Any suggestion on how to prepare for the next upgrade would be
> appreciated.
I think it has to be said that if you want decent performance on excessively
large (50GB+) databases, you're going to need excessively good hardware to
operate it on. Buy a 3ware IDE RAID controller (www.hypermicro.com) and a
stripe a couple of seagate 80GB IDE drives (the new ones have an awesome
transfer rate). Turn of fsync, and use softupdates or even async I/O.
I am guessing though you've already done all of the above. You might have
to go beefier hardware, for PCs that means DDR SDRAM/Rambus, and a 64 bit
PCI 3ware card with 4 or 8 hard drives.
Hope that helps
Andrew