Excessive Server Loads: Need Caching Plugin, If Available

[keiichi_merged]

My forums have become a bit on the large side, some 85,000+ messages on my forums and due to a problem with the DB causing excessive server loads with my webhost I need to know if there's a way to better optimize my database so that it's not interfering with the servers that my webhost provider has. Apparently, it has something to do with the fact that there are too many queries being performed ...

Is there a caching plugin available to help with this problem?

[bfarber]

If you have eaccelerator, memcache or xcache installed that you can use, you can enable it in conf_global.php. i.e.

$INFO['use_xcache'] = 1;

This helps marginally. If you have modifications installed, I'd look at removing some (or all) if the problem is too many queries. IPB does not generate an excessive number of queries by default.

[Bobsuch]

Try the sphinx search mod for IPB