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)

[Deriel]

Really nice Mod, nominated it already

I'm using vB 3.8rc2 and everything seems to be ok. Just one curiosity: using XCache with this mod seems faster than useing memcache (yeap, I have both installed)

[logicuk]

Running php5, memcache 3, vb 3.7

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

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)

So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

[GreasySpoon]

Originally Posted by Deceptor

If anyone has any suggestions, be sure to let me know and I'll try get them in the next update

Maybe precaching the templates? So that the Add-On dont have to check if the Templates, Styles, ... are already cached or not?

Really nice work. Thumbs up :up:

[veenuisthebest]

Originally Posted by logicuk

Running php5, memcache 3, vb 3.7

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

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

[logicuk]

Originally Posted by veenuisthebest

Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

Yes this is the debug info for forum/index.php

I have enabled the mod and selected memcahce

And i cant disable any mods, my site is very custom

[tmc]

Originally Posted by logicuk

Running php5, memcache 3, vb 3.7

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

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

This is just plain wrong.. You don't even explain if it's on the EXACT same page. Seems to me like your website is adding extra queries per post or per thread, (I don't know what script you're taking this info from) and you happen to be comparing different pages.

It's not possible that this mod added 21 queries.

That being said, you really need to hire somebody to fix those query issues and the amount of memory being taken up. I don't quite get how the page you're loading is taking 16MB of memory...

Here's a SHOWTHREAD example:

Page generated in 0.02043104 seconds (73.73% PHP - 26.27% MySQL) with 6 queries 2,085.35KB Used

and FORUMHOME:

Page generated in 0.01459694 seconds (66.00% PHP - 34.00% MySQL) with 5 queries 1,470.00KB Used

[tmc]

Originally Posted by logicuk

Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.

I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

[logicuk]

Originally Posted by tmc

I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

[Lizard King]

Originally Posted by logicuk

Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.

Yes you have a customized style but there is nothing extra on your forum index to run 33 queries

Edit : Sorry i just realized you are also using vbadvanced cmps. That explains everything

[tmc]

Originally Posted by logicuk

And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

As in: That's all it should be taking to pull this information onto FORUMHOME. Given it is properly coded.

It wasn't an actual observation, but my estimate of what your query count should really be. You should hire someone to optimize your queries, as they are probably destroying your server.