PHP Classes

Query caching

Recommend this page to a friend!

      Metabase  >  All threads  >  Query caching  >  (Un) Subscribe thread alerts  
Subject:Query caching
Summary:Does Metabase support this feature?
Messages:2
Author:Matías montes
Date:2006-10-18 18:13:48
Update:2006-10-18 20:16:54
 

  1. Query caching   Reply   Report abuse  
Picture of Matías montes Matías montes - 2006-10-18 18:13:48
I've been working with CodeIgniter (http://codeigniter.com)lateley and in their latest version they added the capability to cache database query results. What they do is save the result object as a seliarized string in a file named like the md5 hash of the query.

Does Metabase support this feature also? if it doesn't, I think it would be cool to add it in a future release.


Regards,
Matías

  2. Re: Query caching   Reply   Report abuse  
Picture of Manuel Lemos Manuel Lemos - 2006-10-18 20:16:54 - In reply to message 1 from Matías montes
I use the file cache class. It is a generic data caching class that keeps cached data in files.

phpclasses.org/filecache

This is not provided as provided as part of Metabase because it can be used for other things besides caching queries.

Other than that, if you want to generate a page that is made of content taken from multiple database queries, it is more efficient to cache the actual HTML of the page, than keeping multiple caches for each query you performed.

These and other performance improvement aspects are explained Metabase FAQ:

meta-language.net/metabase-faq.html ...