Symfony2 cache expiration

Question

I have the following action in my controller :

public function popularPlacesAction()
{
    $em = $this->getDoctrine()->getManager();

    $query = $em->createQuery(
        "SELECT COUNT(s.id) as total, l.city as name, l.country_code as country_code
          FROM AcmeMyBundle:Sample s 
          LEFT JOIN s.location l 
          WHERE l.city != ''
          GROUP BY name
          ORDER BY total DESC"
    )->setMaxResults(15);

    $cities = $query->getResult();

    return array(
        'cities' => $cities
    );
}

I want to use cache to set an expiration date for the response, don't matter if the result of the query have changed. I just want to set the response as public and refresh the response every hour for exemple. How to accomplish this without performing the doctrine query when the response come from the cache ?

zeykzso · Accepted Answer · 2014-03-25 16:10:30Z

3

You need to use some caching method (maybe Varnish or symfony's reverse proxy), and then set some caching headers to your action response. Have a look here: Expiration with the Cache-Control Header ex:

public function popularPlacesAction()
{
    ... 
    $response = new Response();
    $response->setSharedMaxAge(3600);
    $response->setContent(....);
    return $response;
}

Hope this helps. Other docs to read: HTTP Cache

answered Mar 25, 2014 at 16:10

zeykzso

4932 silver badges9 bronze badges

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

3 Comments

Yvan L. Over a year ago

Thank you for your answer. The thing I don't understand about this is : where to put this snippet in my action if I want to execute the doctrine query only when the cached response has expired ?

Jakub Zalas Over a year ago

@YvanL you don't have to. A reverse proxy (like varnish) won't make another request to your app if it still has a fresh response.

Jakub Zalas Over a year ago

Read: symfony.com/doc/current/book/http_cache.html tomayko.com/writings/things-caches-do mnot.net/cache_docs

Collectives™ on Stack Overflow

Symfony2 cache expiration

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related