Login   Register  
PHP Classes

Easy MySQL Cache: Cache MySQL query results in MySQL memory tables

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (1)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2011-11-01 (3 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,337 This week: 1All time: 2,695 This week: 1,384Up
Version License PHP version Categories  
ezmc 0.2GNU General Public Lice...5.0PHP 5, Cache
Description Author  

This class can cache MySQL query results in MySQL memory tables.

It can execute a given MySQL query and store the results in a record of a MySQL table of type MEMORY, so it can be used as cache.

The class can retrieve the results from the cache table if the same query is executed again and the cache has not yet expired.

The MEMORY type cache table can be created automatically when the given database is selected, if it does not yet exist.

Innovation Award  
PHP Programming Innovation award nominee
October 2011
Number 3

Prize: One copy of RadPHP XE
Database queries are often what takes more time to execute when you access a Web page.

This class implements a clever approach to reduce the time to run frequently executed MySQL database queries.

It retrieves the query results and stores them in MySQL tables of type MEMORY. The next time the same query is executed, the results are retrieved much faster from those memory based tables.

Manuel Lemos
Picture of Kaan Tunšel
Name: Kaan Tunšel <contact>
Classes: 1 package by
Country: Turkey Turkey
Age: 40
All time rank: 181433 in Turkey Turkey
Week rank: 1063 Up20 in Turkey Turkey Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Plain text file ezmc.class.php Class Example included

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,337All time:2,695
 This week:1This week:1,384Up
 User Comments (1)  
good job
3 years ago (tuncay bahadir)