PHP Classes

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

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 49%Total: 1,409 All time: 2,769 This week: 57Up
Version License PHP version Categories
ezmc 0.2GNU General Publi...5.0PHP 5, Cache
Description 

Author

Kaan Tunçel

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
  Performance   Level  
Name: Kaan Tunçel <contact>
Classes: 1 package by
Country: Turkey Turkey
Age: 51
All time rank: 192333 in Turkey Turkey
Week rank: 195 Up8 in Turkey Turkey Up

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadezmc-2011-11-01.zip 1KB
Downloadezmc-2011-11-01.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,409
This week:0
All time:2,769
This week:57Up
User Ratings User Comments (1)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:49%StarStarStar
Rank:2774
 
good job
13 years ago (tuncay bahadir)		60%StarStarStarStar
 

  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.