Doctrine 2 - ORM

Introduce batching of eager loads

Details

  • Type: Sub-task Sub-task
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 2.0-ALPHA2
  • Fix Version/s: 2.1
  • Component/s: None
  • Security Level: All
  • Labels:
    None

Description

During hydration when an association is encountered that is configured EAGER this entity is directly loaded through a separate SQL statement. This is inefficient for single-valued associations as it leads to the n+1 queries problem. This should be improved by somehow collecting all entities that need to be eagerly fetched and loading them in a single statement or in batches.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Roman S. Borschel added a comment - - edited

Update: This affects inverse sides of a one-one association since these can never be lazy as well as one-one owning sides that are configured EAGER.

Probably batching of collection loads is also somehow possible but all this needs quite some design and planning before implementation.

Show
Roman S. Borschel added a comment - - edited Update: This affects inverse sides of a one-one association since these can never be lazy as well as one-one owning sides that are configured EAGER. Probably batching of collection loads is also somehow possible but all this needs quite some design and planning before implementation.
Hide
Permalink
Roman S. Borschel added a comment -

Rescheduled.

Show
Roman S. Borschel added a comment - Rescheduled.
Hide
Permalink
Benjamin Eberlei added a comment - - edited

I implemented batching of eager loads for Many-To-One and Owning One-To-One associations so far as part of DDC-952.

Show
Benjamin Eberlei added a comment - - edited I implemented batching of eager loads for Many-To-One and Owning One-To-One associations so far as part of DDC-952 .
Hide
Permalink
Benjamin Eberlei added a comment -

Implemented

Show
Benjamin Eberlei added a comment - Implemented

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Roman S. Borschel
Vote (1)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: