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

Recommend this page to a friend!

Download .zip

Info

View files (1)

Download .zip

Reputation

Support forum (3)

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 1,406		All time: 2,769 This week: 220

Version		License		PHP version		Categories
`ezmc` 0.2		GNU General Publi...		5.0		PHP 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

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