MyBB Community Forums

Ok this looks like an excellent query cutting mod that does this. And the most exciting part is that this can be implemented into modifications/plugins as well!
http://www.vbulletin.org/forum/showthread.php?t=199207

Quote:vB Optimise

vB Optimise is an extension to vBulletin that allows several amounts of globally requested and partially requested data to be cached on-the-fly in multiple ways, effectively improving page loading times, server resources and database resources. Additionally vB Optimise can point out settings on your forum that could be improved to get additional performance and speed.

Example of what vB Optimise does to vBAdvanced


What can it do?

Currently vB Optimise can do the following:

* No Template/File Edits
* Installation will take seconds.
* Cache Templates
* Cache Styles
* Cache Phrases
* Cache Homepage WOL
* Use 'File Cache'
* Use 'Memcache'
* Use 'XCache'
* Use 'APC'
* Use 'eAccelerator'
* Globally reduce your forum queries by two, and chop a 3rd one down.
* Force custom datastore items to use datastore cache correctly (reduces queries by 1).
* Automatically update cache when handling templates, styles or css.
* Check your forum for Optimal settings, to ensure you're using the best settings possible for performance.
* Massively reduce queries for vBAdvanced, upto 10 and more (differs depending on the vBAdvanced modules you have installed).
* Potentially has the ability to cut upto 4 queries, and chop a 5th one down.

How does it work?

vB Optimise works ahead of vBulletin, calling data from the database if it is not already cached, then caching it using any of the three available methods vB Optimise supports. After handling data, vB Optimise pushes the cached data to vBulletin letting it know it no longer needs to query the data.


Can I integrate this into my mod easily?
Integration should be very easy! I've made a seperate mod here which can use vB Optimise: http://www.vbulletin.org/forum/showthread.php?t=199568 Hopefully it should demonstrate to you how to integrate vB Optimise into your mod

Change Log for those interested in how he started it.

Quote:Change Log

- Version 1.3.2
Fixed: Similar issue with 1.3.1, bug still occured on caching modules, but not when retrieved from cache.

- Version 1.3.1
Fixed: Minor issue with cached vBA CMPS Modules, background class of modules wasn't swapping correctly due to variable being cached. (Alt1, alt2, alt1, etc..)

- Version 1.3.0
Added new setting to stop vB Optimise caching phrases in ACP.
Added vBAdvanced Integration Switch, enabling this switch will allow you to edit vBAdvanced modules and cache them for a timed period.

- Version 1.2.1
Fixed: First install users, could sometimes fail when enabling vB Optimise due to connection checks made on cache selections.

- Version 1.2.0
Added Optimal Settings Check System
Added Homepage WOL Cache System
Added Kill Object Hooks to destroy vB Optimise objects when finished, to preserve more resources.
Fixed: Force Datastore Cache ran if vB Optimise was offline
Fixed: Phrase bug on member profiles when viewing as a guest.
Fixed: XCache could not silently flush cache if authentification was required.
Fixed: If modifications passed on invalid templates, vB Optimise attempted to query none-existant templates.

- Version 1.1.0
Corrected Typo
Added option to insert cache title prefix's, helpful for those running multiple vBulletin installations.
Added cache integrity check, to automatically detect corruption and fix on the fly without any errors or obscure content being displayed.
Added kill cache hooks for styles, templates and css. (Thanks to Andreas for pointing out hook locations, and idea).
Added ability to enable Custom Datastore Cache, which will force custom datastore entries to use the actual datastore method your vBulletin is setup with, allowing a reduction of 1 query if any modifications you have installed use custom datastore cache at init_startup (Thanks to Andreas for the idea).
Added support for APC.
Added support for eAccelerator.
Added check when saving vB Optimise settings to ensure the cache method you've selected is supported on your server.
Added SuPHP switch for users using Filecache, to change file permissions to 0644 instead of 0777 for cache files created by vB Optimise. (Thanks to Infopro for pointing this out).

- Version 1.0.2
Fixed php error which showed when logging in
Added option in vB Optimise settings force authentifcation to show up when using XCache
Created check in vB Optimise that ensures ./vboptimise has correct permissions when selecting to use filecache

- Version 1.0.1
Fixed style selections
Changed text in admin cp for online/offline command
Changed text in debug messages for vBulletin Debug