Template Cache System

Vbulletin Template Cache System
Optimize Your Forums!!

Notice:

While filesystem caching does provide a performance increase; it can be futher increased. I plan on including mmcache, eaccelerator, and APC shared memory support in the near future.

This will eliminate the need for reading/writing file to and from the filesystem.


Summary:

This modification will cache the templates that your forum uses to the file system saving you a mysql query.

Normally this data is requested from the database on every page load, with this however we cache all the templates we would normally use into a file to be included as a standard php code.

This will save you a pretty large query, the full size of the templates can be anywhere from 40kb to 200kb per page; even larger on some forums.

It will literally take 1 or 2 minutes to install, not long for the benefits that you receive.

PS. Use this in conjunction with my Other Hack (Compress Forum Templates) for speeding up your forum even more by compressing templates.
https://vborg.vbsupport.ru/showthread.php?t=107615
PS. Use this in conjunction with my Other Hack (Accelerated Plugins) for speeding up your forum even more by Inlining your plugins.
https://vborg.vbsupport.ru/showthread.php?t=107315


Instructions:

1. Download Zip File.
2. Read the INSTALL.txt
3. Click install if you like


Updates:
3/14/2006 8:34am : Large update, adding additional file locking code as well as moved some redundant code into functions. If you have an active site I recommend that you update with the newest version.

3/14/2006 7:07am : Cleaned up the code a little bit, no need to redo the edits unless you are a perfectionist like myself

3/13/2006 12:52 / Typo Update: There was a typo in the global.php edit, please re-do that step.

3/13/2006 11:48 / Massive Critical Update:
1. Automatically caches any uncached templates.
2. Files are now stored as .php files to prevent easy viewing.
I strongly recommend you update ASAP.
Just follow the INSTALL.txt and go through the procedures again.
PS. Make sure to empty the template_cache directory after upgrading. Thankyou.

3/12/2006 12:20pm
1. Now caches most action templates
2. The cache cleaner will not delete index.htm or index.html files.
3. Also updated the install.txt
4. Fixed parse error.
To upgrade, just re-do the code modifications listed in the install.txt file.
PLEASE clear the template_cache directory, after you redo the modifications. The new changes cache the actiontemplates as well.


Troubleshooting:

Start browsing your forum, going to your main page then browsing threads etc.. should start seeing items appear in that template_cache directory such as index_1.php, showthread_1.php etc.. if not you need to give this directory WRITE permissions (CHMOD 777)

[DementedMindz]

Originally Posted by MissKalunji

apc cache?

im thinking he means alternative php cache which is a PECL extension...

[MissKalunji]

Originally Posted by DementedMindz

im thinking he means alternative php cache which is a PECL extension...

oh *clueless*

[Trigunflame]

I havnt even attempted to read through all the replies, as I had to take a break from vbulletin for a few days.. will try to get back to working on all of this stuff asap..

[MissKalunji]

Originally Posted by Trigunflame

I havnt even attempted to read through all the replies, as I had to take a break from vbulletin for a few days.. will try to get back to working on all of this stuff asap..

yaye life savor! will you marry me? lol just joking!

[Bulent Tekcan]

Yes...APC install details is here http://www.vbulletin.com/forum/showthread.php?t=165367 (http://pecl.php.net/package/APC) And many big boards use them.

[The Realist]

Getting a few problems when this hack is enabled. The main one is a database error as follows:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE adminutil SET text = '1143563640' WHERE title = 'datastorelock' AND text < '1143563625';

MySQL Error  : 
Error Number : 
Date         : Tuesday, March 28th 2006 @ 05:34:00 PM
Script       : http://www.tech-tronix.com/search.php?do=getnew
Referrer     : http://www.tech-tronix.com/
IP Address   : 
Username     : Realist
Classname    : vb_database

When I refresh the screen its ok, but when I 1st view a new post this DB error shows up.

Any ideas before I remove this for good.

Also,

It does not cache some of my templates as well.

[Cky47]

I installed all three of his hacks, but I cant figure out what is going on with my sites speed now. It seems liek after I installed them, now a day later, things are slower instead. Users say that they cant tell much of a difference, but I definately can.

Can someone tell me if my pages are loading slow? That or tell me wahts going on?

My site is www.boardingscene.com

I am thinking it could be my hosting too, because I am running a cheap godaddy.com plan. All I know is I need the load times to be as low as possible, because I am buying VbSeo soon.

[CrashfAB]

Quick question. The other 2 plugins are for version 3.5.3 and this one is for 3.5.4 So its ok to run the other too on 3.5.4 ? Sorry for the dumb question I just don't wanna screw my BBS up...

Thanks..

[The Realist]

Removed due to DB errors.

[MissKalunji]

Originally Posted by The Realist

Removed due to DB errors.

do you have the template compressor installed?