Current Version 1.1.0
_______________________________________________________
Note
As the original author of this mod has been banned i have taken over this project and continued development.
_______________________________________________________
Contributions
Any contributions made by third partys and posted in this thread will get a link in think section of the post, i will check this thread daily.
_______________________________________________________
About
With this modification installed you will be able to cache sql queries for faster page generation times and less database usage, the following can be done with this method.
_______________________________________________________
What is SQL caching?
This mod will add an additional parameter to the sql_query function of the sql_db object, this parameter will tell the query to use php files to store queried data for the specified about of time (3hrs by default, you may use a config var to store an alt number) in a php file as a serialized string, this will improve the performance of your forum as done in phpBB3 by reducing the load put onto the mysql service.
_______________________________________________________
How to cache a query!
To cache your SQL query you simply add a cache handle to your sql_query function.
This is your standard query
Code: Select all
$db->sql_query($sql)
Code: Select all
$db->sql_query($sql, true)
Code: Select all
$db->sql_query($sql, true, 'cache_name')
_______________________________________________________
Config keys
sql_cache_dir: Custom caching directory
sql_cache_expire: Custom caching time (in seconds) default: 3hrs
_______________________________________________________
Download Mirrors
[1.1.0] http://www.gotbase.org/mod_sql_caching_110.zip (Thanks A.I. BOT)
[1.1.0] http://www.extremephpbb.com/mods/mod_sq ... ng_110.zip (Thanks danb00)
[1.0.0] http://gotbase.org/mod_sql_caching_100.zip (Thanks A.I. BOT)
_______________________________________________________
Change Log
Changes for each version of this mod
- Version 0.1.0
- # Stable Release
- # Reviewed and submitted to MOD-DB, Forgot about the transaction param, readded.
- # Created caching class
# Cleaned up the code a little
# Added optional config directives
# MOD Takeover by tunafish