Details

    • Type: Sub-task Sub-task
    • Status: 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

        Hide
        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
        Roman S. Borschel added a comment -

        Rescheduled.

        Show
        Roman S. Borschel added a comment - Rescheduled.
        Hide
        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
        Benjamin Eberlei added a comment -

        Implemented

        Show
        Benjamin Eberlei added a comment - Implemented

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Roman S. Borschel
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: