On 6/6/06 9:55 AM, Ruben Rubio Rey wrote:
Im having a trouble using memcached with pear db. When im using memcache to store and retrieve an string, all works fine. When Im using memcache to store a pear db resulset, it does not work!! This retrieves data but pear::db does not understand it. I really dont know
This is because $db->query returns a resource, which is a reference to the data and not the data itself.
For example, let's say you're using the MySQL driver for PEAR::DB, then when you call $db->query(), it uses mysql_query(). This function will return a resource. When you store the resource to the memcache server and then later retrieve it, it no longer maintains its reference to the data.
If you want to store the data to the cache, I suggest you use getAll() to retrieve an array of data and then store that to the memcache server:
$db->setFetchMode(DB_FETCHMODE_ASSOC); $data =& $db->getAll($sSQL); memcache_set($MEMCACHE_STR, MD5($sSQL), $data, 0, 10); Now, your result set is stored properly on the memcache server. -- Ben Ramsey http://benramsey.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
