Doctrine 2 fetch = "EAGER"

Question

In Doctrine, you can set the sampling mode in your entities to retrieve all the data on one request and not lazily load all of them.

/** * @ORM\OneToOne(targetEntity="Application\Entity\Categorie" , fetch="EAGER") * @ORM\JoinColumn(name="CAT_ID", referencedColumnName="CAT_ID") * @access protected * @var \Application\Entity\Categorie */ protected $CAT_ID; 

I have problems with this when it comes to level 3. Entity "a" refers to object "b". Object "b" refers to object "c". Object "a" and object "b" are selected in one request, and entity "c" is separated from them in one request. I set fetch="EAGER" for each relationship between them.

Do not Doctrine handles fetch="EAGER" at level 3, or what happens wrong?

Answer 1

I don’t think so, but what you can do is set the EAGER mode only if necessary

 <?php $query = $em->createQuery("SELECT u FROM MyProject\User u"); $query->setFetchMode("MyProject\User", "address", \Doctrine\ORM\Mapping\ClassMetadata::FETCH_EAGER); $query->execute(); 

For more information, see the Doctrine Docs .