regarding what to cache???

[Ajinkya Nahar]

Hi,

 

I am working on a PHP - Mysql application.

I wanted to ask that can we cache the result set returned by a particular
query into memcached?

If yes, can we fetch the same result set from memcached and use it without
database connection?

 

E.g.

$query = "SELECT * from ..";

     $result = mysql_query($query);

     $memcache_obj->set($key, $result);

 

Will this work??

 

Please let me know your comments.

 

Regards,

Ajinkya