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

  Author Author  
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: 815 Down2 in Belarus Belarus Down
Innovation award
Innovation award
Nominee: 5x

Winner: 1x


  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of Dmitry Sheiko  >  sqlCache API Library  >  Download Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: sqlCache API Library
Base name: sqlcache
Description: Cache database query results in files
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 1147 users
All time rank: 3017
Week users: 1 user
Week rank: 1517 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings  
  Trackback   Applications   Related pages   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Cache Classes for managing cached pages View top rated classes

  Files folder image Screenshots  
sqlCacheModel1.gif
File Role Description
Accessible without login Image file sqlCacheModel1.gif Screen SQL Caching Model
Accessible without login Image file sqlCacheModel2.gif Screen SQL Caching Model


  User ratings  
Not enough user ratings

  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...

Latest pages that reference packages Latest pages that reference packages


  Applications that use this package  
No pages of applications that use this class were specified.
Add link image 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)

  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

Download Download all files: sqlcache.tar.gz sqlcache.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.