What is the difference between fetch="EAGER" and fetch="LAZY" in doctrine

OrmDoctrine OrmMany to-Many

Orm Problem Overview


What is the difference between fetch="EAGER" and fetch="LAZY" in annotation @ManyToOne in Doctrine ?

/**
 * @ManyToOne(targetEntity="Cart", cascade={"all"}, fetch="EAGER")
 */

/**
 * @ManyToOne(targetEntity="Cart", cascade={"all"}, fetch="LAZY")
 */

Orm Solutions


Solution 1 - Orm

To explain it simply, when you are loading an entity and if it has an association with one or more entities, what should doctrine do?

If the association is marked as EAGER, it will fetch and load the associated entity as well.

If the association is marked as LAZY, doctrine will create proxy objects (dummy objects) in place of the actual entity. Only when you make the first call to that associated entity (like $cart->getItems()), doctrine will fetch and load that object(s) from database. (This is the default Behaviour)

Refer: https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/advanced-configuration.html#association-proxies

Solution 2 - Orm

Additional information about the difference between them:

(fetch = "EAGER")

the associated entities will be fetched as soon as the original query target entity is loaded from doctrine. That means there is no additional SQL query on DB.

(fetch = "LAZY")

the associated entities will be fetched ONLY IF the original query target entity calls the reference method, such as $cart->getItems(). That means, there is additional SQL query on DB.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionMohamed Ben HEndaView Question on Stackoverflow
Solution 1 - OrmPradeepView Answer on Stackoverflow
Solution 2 - OrmvikbertView Answer on Stackoverflow