Originally Posted by fusionx

That would be nice :-)

My site(s) are very database dependant. It's actually mySQL that's doing most of the work. Zend optimizer lowered the server load drastically for the site software (Coppermine Photogallery - a badly optimized peice of software) but the database needs more ram/horsepower. The next version of coppermine has much more optimized SQL code, but I can't wait that long :-(

I also run phpAdsNew (another server hog on the DB), that's serving banners to three different sites.

Plus, I'm working on a niche search engine that is probably going to be pretty heavy as well.

If you have any tips on optimizing Apache I'd be very interested in hearing them.

Thanks