PHP Classes

sqlCache API Library: Cache database query results in files

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  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 (9 years ago) RSS 2.0 feedStarStarStarStar 75%Total: 1,176 This week: 3All time: 3,002 This week: 641Up
Version License Categories  
sqlcache 1.0GNU General Publi...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: 40
All time rank: 681 in Belarus Belarus
Week rank: 191 Down1 in Belarus Belarus Equal
Innovation award
Innovation award
Nominee: 5x

Winner: 1x

  • 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,176All time:3,002
 This week:3This week:641Up
User Ratings User Comments (1)  
 All time
5 years ago (kishore kumar)