Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite)

vB Optimise Lite

The newly revamped vB Optimise was created for vBulletin 4, but has now been made compatible for vBulletin 3.8. In this release I have re-coded vB Optimise from the gound and focused stability over features, you'll notice Phrase Caching and vBAdvanced Integration have bit the dust, this is to maintain a sync state between this version and the vBulletin 4 release.

Professional version & feature list available @ www.DragonByte-Tech.com/forum
Priority support for Lite version is handled at the Developers Website.


What does it do?

vB Optimise is intended to optimise vBulletin software by integrating several PHP "cachers" and handling data before vBulletin. This works by encountering and handling data prior to vBulletin in order to skip the arbitary execution that would be more server intensive.

Real-Life Statistics

We've teamed up with some Big Forums to show you the impact of vB Optimise, you can view this public chart which shows both our statistics and theirs:

View Public vB Optimise Resource Statistics

Features

• Supported Extensions
  • APC
  • eAccelerator
  • Memcache
  • XCache
  • WinCache
  • Filecache
• Style Cacher
  Caches style data to globally reduce a query within all vBulletin forum-based pages.
• Template Cacher
  Caches template data to globally reduce a query within all vBulletin forum-based pages.
• Datastore Cacher
  Forces custom datastore items from modifications (including those from vB's blogs) to use your configured Datastore Cache method instead of being forced into the database. This reduces page queries by where affected.
• vB CMS Template Caching
  (Automatic) Corrects many uncached templates within vB CMS to reduce upto 20+ queries on CMS pages (number varies based on content).
• Optimal Settings Check
  Provides a quick interface to identify possible settings which can be changed on your forum for further optimisation.
• Self-System Tester
  Provides a relatively straight-forward system check to ensure your vB Optimise installation works fully.
• Automatic Cache Flusher
  Automatically flushes cache within the Admin CP based on specific triggers to make sure content does not remain stale on your forum.
• XCache Authentification
  Supports XCache Admin Authentification by allowing you specify the username/password in a configuration if needs be.

Features - Pro

• Notices Cacher
  Caches users dismissed notices to reduce a near-global query within all vBulletin forum-based pages.
• Showgroups Cacher
  Caches the showgroups query which becomes more intensive as your user-base grows.
• Forum Display Query Enhancement
  Enhances a stock vBulletin query within Forum Display to speed up the page.
• Forum Home WOL Cache
  Caches Forum Home "Who's Online" to remove an intensive query and allow larger sites to display this data without impact.
• vB Cache Override (Feature not available on vBulletin 3)
  Ability to override vBulletins new built-in database cacher for the CMS / Forum Sidebar Blocks to remove anything from 1 to 20+ queries based on your content.
• Full Guest Caching
  Ability to cache entire pages and serve them saving not only hundreds of queries but upto 90% of CPU processing towards Guests.
• Statistical Resource Savings
  Ability to see just exactly how many queries per day vB Optimise has saved your database. You'll be surprised at the numbers.
• Forum Resource Statistic
  Shows off vB Optimise resource saving statistics directly within forumhome statistics.
• ....and more!

Release Notes

If you've used vB Optimise before you'll be aware the previous version had phrase caching, however this caused complications with the way phrases are used within vBulletin so it has not been ported over at this time.


Available Translations
v1.6.0 French - Thanks to finereader

Change Log

[>>] Version 2.0.1
New launch for vB 3.8

[>>] Version 1.6.1
Automatic Cache Flusher has additional parameters to make sure no data is stale
Resolved Bug: Potential PHP error when using eAccelerator which cannot flush within Admin CP on certain actions

[>>] Version 1.6.0
New OpCode Cacher Support: WinCache

[>>] Version 1.5.0
Resolved Bug: Style cache may have fetched ID 0 instead of correct file
Resolved Bug: Filecache permissions may not have worked
Optimisation: Re-wrote some base code to enhance operations.

[>>] Version 1.0.1
Added XCache Authentification Support
Added Filecache Support

Support

Priority support will be handled at DBTech.

FAQ

Q: I have WinCache installed, but vB Optimise tells me it's not?
A: WinCache only introduced OpCode support in version 1.1, if you're using version 1.0.x you will need to upgrade.

Q: I'm using the XCache method, flushing doesn't work?
A: If you have XCache authentification, turn the admin option on within vB Optimise Settings, then edit ./vboptimise/config.php and specify your XCache username/password. Alternatively you can disable XCache authentification within php.ini:

xcache.admin.enable_auth = Off

Q: I have eAccelerator installed, but vB Optimise tells me it's not?
A: eAccelerator does not provide the caching extension by default, you will need to recompile PHP with additional flags. For more information read eAccelerator documentation located here: http://eaccelerator.net/wiki/CompileConfiguration (Specifically look at: with-eaccelerator-shared-memory)

[ssslippy]

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.

[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

[Bounce]

Originally Posted by Deceptor

does your vBulletin datastore run off of eAccelerator?

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

[veenuisthebest]

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.

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.

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

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

Thanks

[Deceptor]

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.

[logicuk]

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

[veenuisthebest]

Originally Posted by logicuk

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

[logicuk]

Originally Posted by veenuisthebest

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

[tmc]

Originally Posted by logicuk

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.

[Deceptor]

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