Recommend this page to a friend! |
Download .zip |
Info | Screenshots | View files (9) | Download .zip | Reputation | Support forum (1) | Blog | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2005-10-24 (11 years ago) | 76% | Total: 1,324 This week: 3 | All time: 2,818 This week: 377 |
Version | License | Categories | ||||
sqlcache 1.0.0 | GNU General Publi... | Databases, Cache |
Description | Author | ||||||||||||||
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. |
Screenshots | ||
Files |
File | Role | Description | ||
---|---|---|---|---|
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 | ||
readme.txt | Doc. | Short documentation | ||
sqlcache.lib.php | Class | SQL Cache Class Library | ||
test.sql | Data | Sample of DB |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
0% |
|
|
User Ratings | User Comments (1) | ||||||||||||||||||||||||||||||||||
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.
Related pages |
ADOdb Database Abstraction Library for PHP ADOdb is a database abstraction library for PHP |
PHPBB DAL PHPBB Database Abstract Layers Library (DB folder of PHPBB main package) |
Pages that reference this package |
50+ Extremely Useful PHP Classes & Libraries In the past, we’ve discussed several methods you can use to reduce hand coding by use code generators or even APIs... |