PHP Classes
Icontem

Subject: Query caching


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
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  
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  
Picture of Manuel Lemos
Manuel Lemos
2006-10-18 20:16:54
I use the file cache class. It is a generic data caching class that keeps cached data in files.

http://www.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:

http://www.meta-language.net/metabase-faq.html#performance

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products