MySQL: Query Cacheing (How do I use memcache?)

Question

I have an query like:

SELECT id as OfferId FROM offers
WHERE concat(partycode, connectioncode) = ? 
AND CURDATE() BETWEEN offer_start_date 
AND offer_end_date AND id IN ("121211, 123341,151512,5145626 ");

Now I want to cache the results of this query using memcache and so my question is

How can I cache an query using memcache.
I am currently using CURDATE() which cannot be used if we want to implement caching and so how can I get current date functionality without using CURDATE() function ?

Is this question clear or does it need some more modifications ? — Rachel
– Rachel, Commented Apr 2, 2010 at 18:11
For Memcache look here: stackoverflow.com/questions/2512571/… and stackoverflow.com/questions/2444011/memcache-vs-mysql-in-memory — lexu
– lexu, Commented Apr 2, 2010 at 18:34
I'm highly sceptical about many of the memcache questions here...people seem to think that memcache is a necessary addition for any [web] application, without any feel for what kinds of data can usefully be put in it. memcache is not a magic fix to make queries faster; with suitable indexes and cache in the database itself, simple queries like this should be fine without it. memcache adds complexity and potentially consistency problems: don't add it to a project until you really need to. — bobince
– bobince, Commented Apr 3, 2010 at 0:00

Matt · Accepted Answer · 2010-04-02 18:40:54Z

1

Something like this should work:

function getOffers($ids) {
    $key = implode(',', $ids);

    $cache = new Memcache();
    $cache->connect('localhost');
    $content = $cache->get($key);
    if ($content === false) {
        // content is not cached, so we have to run the query
        $content = $yourDb->query('your query here');
        $cache->add($key, $content);
    }

    $cache->close();

    return $content;
}

getOffers(array('121211','123341','151512','5145626'));

You can take this a step further by sorting $ids so that the same "set" of IDs (but in a different order) will still take advantage of an available cache for that set.

This isn't date-sensitive, but you can make it date sensitive by adding the date string to $key

answered Apr 2, 2010 at 18:40

Matt

44.1k6 gold badges105 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

MySQL: Query Cacheing (How do I use memcache?)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related