Msg#: 3406863 posted 3:21 am on Jul 28, 2007 (gmt 0)
I've used eAccelerator with success for busy sites - the one downside to this cache system is that its directory apparently needs to be deleted of all cached files before restarting Apache. This is one step that is easily forgotten without a special script to do it automatically and can be cumbersome.
The first thing that you would want to do before adding any cache system is to see if/how you can optimize your database queries. Use MySQL's EXPLAIN function to see how well a query is performing: