Board Optimization - Load templates from XCache

By default vBulletin loads templates out of the database which means that all templates that are required on a page must be loaded ("cached") before the first template gets rendered.

If a template is not cached an additional dataase query is required.

This Add-on loads templates from XCache on demand, completely emiminating the need for database reads after an initial pageload.

By loading templates on demand only those templates that are really being used on a page will be loaded into memory, so theoretically this Add-on should

• Decrease memory footprint
• Decrease page creation time (as loading data from a shared memory storage like XCache is faster than DB access)
• Remove 1+X (X = amount of uncached templates) queries per page

How is that different to other existing tools like vBOptimise?
Most existing tools (at least the ones I know of) load all templates upfront, just like vBulletin would do if the DB is used.
This means that only those templates that are explicitly cached will be loaded from the cache, uncahed templates will cause additional database queries.

Can I use this Add-on my hared Webhosting?
Most likely not as it requires XCache with variable caching enabled which is usually not the case on shared hosts

I use multiple webservers, is that a problem?
It should work just fine with multiple webservers but that has not been tested so far.

Are there any other drawbacks?
Yes, this Add-on might be (be is not necessarily) incompatible with Add-ons that manipulate the template cache at runtime (which is a technique that is genreally deprecated).

History
1.0.0 Beta 1
First Public Release

1.0.0 Beta 2

• Fixed incorrect variable initialisation that caused problems with other Add-ons that manipulate the template cache
  Important: Such techniques (like using str_replace(), etc.) are deprecated and it is strongly advised not to use Add-ons that do such auto-template changes.
• Increased Plug-in execution order to the maximum to ensure all Templates cached via Plug-ins are grabbed

1.0.0 Beta 3

• Fixed missing global in Hook template_compile
• Added prefix setting to config.php

[ImmortalForums]

blog_postbit_blog_link
blog_postbit_entries_link
postbit_ip
threadadmin_imod_menu_post

Not getting cached and its causing certain users on my forums to not be able to see threads. If I log in as the user I can see the threads though.

[oddmud]

Originally Posted by rob01

cant use XCache

shared hosting :S

my shared hosting has xcache.

[hilfe-forum]

Hmm not work for me...

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/includes/class_core.php(4429) : eval()'d code on line 1

[gibigbig]

not working on vb 4.1.3 with vboptimise enabled

white screens mayyyn

[hilfe-forum]

Help please

[Tue May 31 05:00:04 2011] [error] [client 92.226.138.146] PHP Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/includes/class_core.php(4448) : eval()'d code on line 1, referer: http://www.xxx.de/

[fabiocesar]

Originally Posted by gibigbig

not working on vb 4.1.3 with vboptimise enabled

white screens mayyyn

disable all option with vboptimise.. xD

[Neo_obs]

I am getting a problem with sending new private messages in 4.1.4 anyone else?

Is vboptimise good? I had issues before.

[TheComputerGuy]

I +1 for 3.8

[cherylferraro]

Working for me on 4.1.4.

Great mod, thank you for sharing it.

[washingtonboise]

4.1.4. PL2, fully patched and up to date.

Attempted install. Got fatal error message followed by about 30 pages of verbose text.

Fatal error: Xcache not installed in [path]/includes/adminfunctions_plugin.php(931) : eval()'d code on line 3
#0 vb_error_handler(256, Xcache not installed, /home/rpgresel/public_html/includes/adminfunctions_plugin.php(931) : eval()'d code, 3, Array ([xml] => This Add-on uses XCache to cache templates 1.0.0 Beta 3 '); require_once(DIR . '/includes/class_dbalter.php'); $dbalter = new vB_Database_Alter_MySQL($db); echo('
Altering Table style ...'); vbflush(); $dbalter->fetch_table_info('style'); $dbalter->add_field(array ( 'name' => 'revision', 'type' => 'INT', 'length' => '11', 'null' => false, 'default' => NULL, )); echo('Done!
'); vbflush(); echo(''); vbflush();]]> '); require_once(DIR . '/includes/class_dbalter.php'); $dbalter = new vB_Database_Alter_MySQL($db); echo('
Altering Table style ...'); vbflush(); $dbalter->fetch_table_info('style'); $dbalter->drop_field('revision'); echo('Done!
'); vbflush(); echo(''); vbflush();]]> cache_templates templatecache = new TemplateCache_XCache($cache, $vbulletin, $GLOBALS['style']);]]> template_compile db->shutdown_query("UPDATE " . TABLE_PREFIX . "style SET revision = revision + 1", 'stylerevision');]]> ,[allow_overwrite] => 1,[vbphrase] => Array ([1_day_ago] => 1 Day Ago,[1_hour_ago] => 1 Hour Ago,[1_minute_ago] => 1 Minute Ago,[1_week_ago] => 1 Week Ago,[VSa_APBOUPC] => VSa - Advanced Permissions Based on Post Count,[a_closed_forum] => A Closed Forum,[accept] => Accept,[action] => Action,[active_members] => Active Members,[active_subscriptions] => Active Subscriptions,[add_as_contact] => Add as Contact,[add_as_friend] => Add as Friend,[add_new_folders] => Add New Folders,[add_subscription] => Add Subscription,[add_x_to_contacts] => Add %1$s to Your Contacts,[adjust] => Adjust,[admin] => Admin,[admin_control_panel] => Admin Control Panel,[admin_required_register] =>