Login   Register  
PHP Classes
elePHPant
Icontem

sqlCache API Library: Cache database query results in files

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   Screenshots Screenshots   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-10-24 (8 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,151 All time: 3,019 This week: 1,508Up
Version License Categories  
sqlcache 1.0GNU General Public Lice...Databases, Cache
Description Author  

This package can be used to cache the results of SQL database query results in files.

The idea is to increase database application performance by avoided to access databases to retrieve the results of queries being executed repeatedly.

This package provides an API that encapsulates the execution and caching of SQL database queries that maybe executed by several types of database APIs. Currently it supports supports AdoDB and PHPBB DAL.

The package stores cached result sets in files and one table of the database for indexing.

Picture of Dmitry Sheiko
Name: Dmitry Sheiko <contact>
Classes: 9 packages by
Country: Belarus Belarus
Age: 39
All time rank: 671 in Belarus Belarus
Week rank: 259 Down1 in Belarus Belarus Equal
Innovation award
Innovation award
Nominee: 5x

Winner: 1x

Screenshots  
  • sqlCacheModel2.gif
  • sqlCacheModel1.gif
  Files folder image Files  
File Role Description
Files folder imagecache (1 file)
Files folder imagephpbb_dbapi (1 file)
Plain text file adodb.sqlapi.lib Class SQL API Extension of AdoDB
Plain text file adodb_sample.php Example Sample of ADODB SQL Caching extension
Plain text file phpbb.sqlapi.lib.php Class SQL API Extension of PHPBB DAL
Plain text file phpbb_sample.php Example Sample of PHPBB DAL SQL Caching extension
Plain text file readme.txt Doc. Short documentation
Plain text file sqlcache.lib.php Class SQL Cache Class Library
Plain text file test.sql Data Sample of DB

  Files folder image Files  /  cache  
File Role Description
  Plain text file index.php Example Cache folder (it needs 777 permission)

  Files folder image Files  /  phpbb_dbapi  
File Role Description
  Plain text file mysql.php Example PHPBB MySQL Layer for example

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,151All time:3,019
 This week:0This week:1,508Up
 User Comments (1)  
 
Excellent
4 years ago (kishore kumar)
80%StarStarStarStarStar