[Deceptor]

ssslippy, I use a seperate data prefix just to ensure there's no collision with vBulletin

veenusisthebest,

Regarding #1, I'm looking into caching the forums now, it'd probably be a timed cache like the WOL will be, so the query can only be executed once every minute or hour if you like. Ofcourse the issue will be for those without auto flush cache due to XCache limitations like yourself may see stale data, since the last post info is updated regularly.

That said, if you put the timed cache for forums to 30 seconds, then the last post info data would ofcourse only have a maximum potential of being stale data for 30 seconds, and does reduce another query on several pages.

As for number 2, the statistics don't require a query as vBulletin already handles this with the datastore, assuming you have a decent datastore method (XCache/Memcache, etc..) setup with vBulletin then it's no problem, the only other query that might occur is when showing events from the calendar on the homepage, but these too are already cached by vBulletin.

Effectively the forum homepage only queries several things with the new version: Session, Userinfo, Forums and Moderators. This is only 4 queries, and ofcourse there are two other queries that execute as shutdown queries that occur on all vB pages (mostly, anyway).

If I can time cache the forums, and moderators part, the forumhome would go down to 2 queries (and the 2 hidden shutdown queries), which would be great