CODEWITHSUNDEEP
memcached
tom
tom

Reputation: 14513

memcached - how to use it for multiple records returned from single SELECT operation?

memchached is useful for caching and looking up of single independent records. For the multiple records returned from doing a SELECT operation, how could I make good use of the memcached for caching and looking up later?

Upvotes: 0

Views: 712

Answers (1)

Dasun
Dasun

Reputation: 3294

I didn't get you. If you use php or .net (Enyim client) you can store your result in to an object and set it in to the memcached. (Client will serialize the object and store it in the memcached.)

Following example will store one or more records (results) returned by the db query.

//Init Memcache, Try avoid multiple init if possible  because this is a costly operation 
$memcache = new Memcache;
$memcache->connect('localhost', 11211) or die ("Could not connect");

mysql_pconnect("localhost","root","");
mysql_select_db("YOURDB");

$query = "SELECT * FROM table where `firstname`='dasun';";
$key = md5($query);
$get_result = $memcache->get($key);

if ($get_result) {
    print_r($get_result);
    echo "It's a hit! :)";
}
else {
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    print_r($row);

    // Store the result for 5 minutes
    $memcache->set($key, $row, TRUE, 300); 
    echo "Not a hit. :(";
}

Upvotes: 2

Related Questions