Please note when you install this mod the first view of any page will then put the item into the cache. That means those that just installed it and got more queries, vbulletin needs to put its data back into the cache after a clear.

Also on a side note if possible this should automatically use the pre built in data prefix that is in the config.php file.

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 :)

I have no idea lol (but judging from what you say I guess not),my host installed it,will ask them :up:

So is there a solution for this? The ones who do not have auto-flush cache, how would they be able to see new data ever ?

And if I edit a template, how would I be able to view the change when the cache is not being cleared.

oh man you are going to make all vbulletin sites run on cache completely haha.

Thanks

The solution would only be removing XCache authentification, or just going to Flush Cache each time you change anything with styles, phrases or templates. Ofcourse this still applies with other cache methods as vB Optimise does not always automatically refresh cache when data is updated, just currently on the common methods: edit templates, style variables, css information.

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.19917 seconds
* Memory Usage 16,186KB
* Queries Executed 29 (?)

Great work Deceptor, nominated for MOTM :)

You have a wonderful looking site logicuk, but compromising it with 16mb of memory (5 times the normal) and 33 queries (more than 3 times the normal) is way too much.

Optimizing your forum to reduce it to a considerable number would help you more than this mod :)

I have a dedicated server with dual core cpu and 4gb ram, its all good :)

.... But then you're wasting loads of money a month on a server you shouldn't actually need.

Looking forward to the new release, Deceptor. :)

1.2.0 released :) Check the top post for details on bug fixes and additions :)