|Ratings||Unique User Downloads||Download Rankings|
|76%||Total: 1,369 This week: 1||All time: 2,820 This week: 228|
|sqlcache 1.0.0||GNU General Publi...||Databases, Cache|
This package can be used to cache the results of SQL database query results in files.
SQL Caching API Library Are there troubles with your DB performance? Use SQL Caching API Library. This library extends a DB Abstract Layer API up to SQL Caching ability. SQL Caching API Library 1.0 supports AdoDB (http://adodb.sf.net) and PHPBB DAL (http://phpbb.com). As far as you see in the examples you have to initiate a DB connection by means of the sqlAPI class constructor. You can use the getFetchListing() method of this class for any SQL query, which returns a set of data rows. If you wish to use caching, you suffice to add APPLYCACHE parameter. Also you must apply modify method for every modifying SQL query. You may get the trace log from TraceInfo array. The cleanCache method allows to clean cache. The library uses files for cache storage and one table of DB for indexing. You can rewrite this API in order to cache is kept in server shared memory (see http://php.net/shmop_open/) How install? Restore test.sql dump into your DB. Create /cache/ folder and set up 777 permission to it. Copy into /adodb/ folder AdoDB files or copy into /phpbb_dbapi/ folder PHPBB DAL files. If you don’t use any DAL API copy into /phpbb_dbapi/ folder mysql.php and execute phpbb_sample.php.
|cache (1 file)|
|phpbb_dbapi (1 file)|
|adodb.sqlapi.lib||Class||SQL API Extension of AdoDB|
|adodb_sample.php||Example||Sample of ADODB SQL Caching extension|
|phpbb.sqlapi.lib.php||Class||SQL API Extension of PHPBB DAL|
|phpbb_sample.php||Example||Sample of PHPBB DAL SQL Caching extension|
|sqlcache.lib.php||Class||SQL Cache Class Library|
|test.sql||Data||Sample of DB|
|Version Control||Unique User Downloads||Download Rankings|
|User Ratings||User Comments (1)|