What is the difference between fetch="EAGER" and fetch="LAZY" in doctrine
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
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.