Caching multiple queries with memcached

Question

What is the way to cache multiple queries with memcached in PHP? Suppose a page takes two queries to render, do I need to use two separate keys and access $memcache twice?

Here's an example:

   $id = $_POST["id"];
   $memcache = new Memcache;
   $memcache->connect('localhost', 11211) or die ("Could not connect");

   $dbh = new PDO("mysql:host=$hostname;dbname=$databasename", $username, $password);
   $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

   $key1 = "{$id}1"; 
   $key2 = "{$id}2"; 

   $cache_result = array();
   $cache_result = $memcache->get($key);
   $cache_result2 = array();
   $cache_result2 = $memcache->get($key2);

   if($cache_result || $cache_result2)
   {
     $rows =$cache_result;
     $rows2 = $cache_result2;
   }
   else
   {
    $sql = "call load_this(?);";
    $users = $dbh->prepare($sql);
    $users->bindValue(1, 1, PDO::PARAM_INT);
    $users->execute();
    $rows = $users->fetchAll(PDO::FETCH_ASSOC);
    $memcache->set($key, $rows, MEMCACHE_COMPRESSED, 1200); 

    $sql = "Call load_that(?)";
    $users = $dbh->prepare($sql);
    $users->bindValue(1, 2, PDO::PARAM_INT);
    $users->execute();
    $rows2 = $users->fetchAll(PDO::FETCH_ASSOC);
    $memcache->set($key2, $rows2, MEMCACHE_COMPRESSED, 1200); 

    print "NOT_CACHED";  
   }

"do I need to use two separate keys and access $memcache twice" --- it depends. Do you want to store them separately or together? — zerkms
– zerkms, Commented Nov 4, 2014 at 21:59
@zerkms I need to loop over rows and `rows2´ separately, so I guess I can't store them in one key. — RedGiant
– RedGiant, Commented Nov 4, 2014 at 22:04

Dany Caissy · Accepted Answer · 2014-11-04 22:00:43Z

1

You can do it however you want...

If they are going to be cached at the same time, you can also simply do this:

$memcache->set('key', array('result1' => $rows, 'result2' => $rows2), MEMCACHE_COMPRESSED, 1200);

This would cache both results in the same object and would require less calls to memcached, but the different in performance wouldn't be meaningful.

answered Nov 4, 2014 at 22:00

Dany Caissy

3,21617 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RedGiant Over a year ago

Thak you. I will try it out. How should I fetch the data? $memcache->get('result1'); ?

Dany Caissy Over a year ago

No, you will use one key, in my example, it would be get('key'); This would return an array containing both your results.

Collectives™ on Stack Overflow

Caching multiple queries with memcached

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related