Caching the Orm result question

Question

Caching the Orm result question

graphmatic May '16

Created May '16	Last Reply May '16	Replies 2	Views 292	Votes 0

graphmatic 11.6k

May '16

Stupid question probably..When using a cache system to cache a resultset, does it's needed to explicitely ask the cache (here Redis) if the key exist before triggering the query or the framework do that automaticaly?

example, in my action to retrieve all clients: does this is enough:

    $clients = Clients::find(
            array(
                "cache" => array(
                    "key" => "clients-list"
                )
            ));

or do I need to write :


    $clients   = $this->di->cache->get("clients-list");
    if(!$clients){
            $clients = Clients::find(
                    array(
                        "cache" => array(
                            "key" => "clients-list"
                        )
                    ));
            }

Jonathan Aaron Steel
79.0k

Accepted
answer

edited May '16
May '16

If you're satisfied with 3600 seconds (1 hour) as cache lifetime, then sure, first example is good.

Otherwise, provide lifetime and custom service which will be responsibile for ORM caching:

'cache' => ['lifetime' => 15 * 60 , 'key' => 'my-query-alias', 'service' => 'myOrmCacheService']  
//'modelsCache' is the default name for the models cache service

Note: you don't have to supply service key, since it will use default 'modelsCache'. I'm using my own service, thus I supply it's name in order to be fetched by IoC.

This is how Phalcon handles it by default:

Class Phalcon\Mvc\Model\Query will get result set from cache for you:

    let result = cache->get(key, lifetime);
                if result !== null {
                .... do it...
                }

So no, you don't have to call cache object manually.

graphmatic · Answer 1 · 2016-05-18T03:29:09-07:00

graphmatic
11.6k

May '16

thank you for the clarification..magic is everywhere!

Jonathan Aaron Steel · Answer 2 · 2016-05-19T09:20:57-07:00

Question: have you tried with lifetime > 1 day (86400 seconds), does it work/refresh after that time?

graphmatic · Answer 3 · 2016-05-19T11:35:33-07:00

I'm using redis cache without lifetime, only manual cleaning when some operations are done that then need the cached query to be rebuild

Question: have you tried with lifetime > 1 day (86400 seconds), does it work/refresh after that time?