Demystifying cache in Doctrine ORM

Applications should be fast regardless of any cache system. However, sometimes we do need to cache data in order to optimise things and deliver a fast response to the clients.
This talk covers the different types of cache offered Doctrine ORM (metadata, query, result set, and second level cache), how they work together with the Unit of Work and what we should know before caching all the things.

Transcript

1. Demystifying Luís Cobucci
 @lcobucci https://goo.gl/oZPuRc cache in Doctrine ORM
2. Reliability https://goo.gl/1shwsY
3. Maintainability https://goo.gl/D4DvKC
4. Scalability https://goo.gl/M67mS8
5. Trade-offs https://goo.gl/L7YdSp
6. Minions of users! https://goo.gl/7MAkHZ
7. “ There are two hard things in Computer Science: cache invalidation, naming things, and off-by-one errors Common sense
8. Luís Cobucci
 @lcobucci
9. “ a hardware or software component that stores data so future requests for that data can be served faster; the data stored in a cache might be the result of an earlier computation, or the duplicate of data stored elsewhere. Cache (computing) - Wikipedia
10. Our software Cache External API
11. Our software Cache External API 1. Give me “external.result”
12. Our software Cache External API 2. Cache miss 1. Give me “external.result”
13. Our software Cache External API 2. Cache miss 3. Give me data 1. Give me “external.result”
14. Our software Cache External API 2. Cache miss 3. Give me data 4. There you go 1. Give me “external.result”
15. Our software Cache External API 2. Cache miss 1. Give me “external.result” 3. Give me data 4. There you go 5. Store “external.result”
16. Our software Cache External API 2. Cache miss 1. Give me “external.result” 3. Give me data 4. There you go 5. Store “external.result” 6. Stored!
17. Our software Cache External API 1. Give me “external.result”
18. Our software Cache External API 2. Cache hit! 1. Give me “external.result”
19. Doctrine ORM? https://goo.gl/xCBz84
20. Template Message Consumer Campaign 1 1 1 * * *
21. Template Message Consumer Campaign 1 1 1 * * *
22. Template Message Consumer Campaign 1 1 1 * * * Order matters
23. Template Message Consumer Campaign 1 1 1 * * * INSERT INTO consumer (name, email)
 VALUES (“Luís Cobucci”, “luis@me.com”);
 SET @consumer_id = LAST_INSERT_ID();
24. Template Message Consumer Campaign 1 1 1 * * * INSERT INTO consumer (name, email)
 VALUES (“Luís Cobucci”, “luis@me.com”);
 SET @consumer_id = LAST_INSERT_ID(); INSERT INTO template (name, body)
 VALUES (“Template 1”, “blah… blah… blah…”);
25. Template Message Consumer Campaign 1 1 1 * * * INSERT INTO consumer (name, email)
 VALUES (“Luís Cobucci”, “luis@me.com”);
 SET @consumer_id = LAST_INSERT_ID(); INSERT INTO template (name, body)
 VALUES (“Template 1”, “blah… blah… blah…”); INSERT INTO campaign (title, template_id, message)
 VALUES (“Test”, LAST_INSERT_ID(), “blah… blah… blah…”);
26. Template Message Consumer Campaign 1 1 1 * * * INSERT INTO consumer (name, email)
 VALUES (“Luís Cobucci”, “luis@me.com”);
 SET @consumer_id = LAST_INSERT_ID(); INSERT INTO template (name, body)
 VALUES (“Template 1”, “blah… blah… blah…”); INSERT INTO campaign (title, template_id, message)
 VALUES (“Test”, LAST_INSERT_ID(), “blah… blah… blah…”); INSERT INTO message (campaign_id, consumer_id, sent)
 VALUES (LAST_INSERT_ID(), @consumer_id, FALSE);
27. Template Message Consumer Campaign 1 1 1 * * * INSERT INTO consumer (name, email)
 VALUES (“Luís Cobucci”, “luis@me.com”);
 SET @consumer_id = LAST_INSERT_ID(); INSERT INTO template (name, body)
 VALUES (“Template 1”, “blah… blah… blah…”); INSERT INTO campaign (title, template_id, message)
 VALUES (“Test”, LAST_INSERT_ID(), “blah… blah… blah…”); INSERT INTO message (campaign_id, consumer_id, sent)
 VALUES (LAST_INSERT_ID(), @consumer_id, FALSE); Don’t forget to use a transaction!
28. EntityManager persist() flush() find() remove()
29. declare(strict_types=1); $consumer = new Consumer('Luís Cobucci', 'luis@me.com');
 $template = new Template('Template 1', 'blah… blah… blah…');
 $campaign = new Campaign($template, 'Test', 'blah… blah… blah…');
 $message = new Message($campaign, $consumer, false);
 
 $entityManager->persist($consumer); $entityManager->persist($template); $entityManager->persist($campaign); $entityManager->persist($message); $entityManager->flush();
30. declare(strict_types=1); $consumer = $entityManager->find('Consumer', 2); $campaign = $entityManager->find('Campaign', 1);
 
 $message = new Message($campaign, $consumer, false);
 
 $entityManager->persist($message); $entityManager->flush();
31. http://goo.gl/gH0hsx Amazing, right?
32. Make it fast! https://goo.gl/6Y2kQd
33. Metadata https://goo.gl/AhjBFJ
34. /** @ORM\Entity */ class Consumer
 {
 /** 
 * @ORM\Id
 * @ORM\GeneratedValue 
 * @ORM\Column(type="integer")
 */ private $id;
 
 /** @ORM\Column(type="string") */
 private $name;
 
 /** @ORM\Column(type="string") */
 private $email; }
35. /** @ORM\Entity */ class Consumer
 {
 /** 
 * @ORM\Id
 * @ORM\GeneratedValue 
 * @ORM\Column(type="integer")
 */ private $id;
 
 /** @ORM\Column(type="string") */
 private $name;
 
 /** @ORM\Column(type="string") */
 private $email; } ClassMetadata
36. Query https://goo.gl/nuFRba
37. SELECT consumer FROM Consumer consumer;
38. SELECT consumer FROM Consumer consumer; SELECT
 c0.id AS id_0,
 c0.name AS name_1, c0.email AS email_2,
 FROM consumer c0;
39. Result set https://goo.gl/7yah7S
40. $query = 'SELECT COUNT(m) FROM Message m WHERE m.user = :user'; 
 $count = $entityManager->createQuery($query)
 ->setParameter('user', 1)
 ->getSingleScalarResult();
41. $query = 'SELECT COUNT(m) FROM Message m WHERE m.user = :user'; 
 $count = $entityManager->createQuery($query)
 ->setParameter('user', 1)
 ->useResultCache(true)
 ->useResultCacheLifeTime(3600)
 ->getSingleScalarResult();
42. L2C https://goo.gl/8pbG3y
43. https://goo.gl/cuLYT9 Bugs…
44. https://goo.gl/1y3fvm Bugs…
45. https://goo.gl/D3Gw7e Bugs…
46. EntityManager UnitOfWork DB
47. EntityManager UnitOfWork L2C DB
48. /**
 * @ORM\Entity
 * @ORM\Cache(usage="NONSTRICT_READ_WRITE")
 */ class Consumer
 {
 // …
 }
49. /**
 * @ORM\Entity
 * @ORM\Cache(usage="NONSTRICT_READ_WRITE")
 */ class Consumer
 {
 // …
 } READ_ONLY
 NONSTRICT_READ_WRITE
 READ_WRITE
50. /**
 * @ORM\Entity
 * @ORM\Cache(usage="NONSTRICT_READ_WRITE")
 */ class Message
 {
 // …
 
 /**
 * @ORM\ManyToOne(targetEntity="Consumer") * @ORM\Cache(usage="READ_ONLY") */
 private $consumer; 
 // …
 }
51. $query = ‘SELECT m FROM Message m WHERE m.user = :user'; 
 $messages = $entityManager->createQuery($query)
 ->setParameter('user', 1)
 ->setCacheable(true)
 ->getResult();
52. https://goo.gl/bGP8u8 Intense traffic
53. Demystifying Luís Cobucci
 @lcobucci https://goo.gl/oZPuRc cache in Doctrine ORM
54. Thanks! @lcobucci