Doctrine 2 - ORM

Several features to batch eager selects more efficently

Details

  • Type: New Feature New Feature
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: 2.x
  • Component/s: ORM
  • Security Level: All
  • Labels:
    None

Description

This ticket aggregates several strategies to optimize batching of eager selects.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment - - edited

Requirements for batching of eager loads:

1. Since we are using an IN() query for this we can only support this feature for entities that have a single column primary key.
2. If we want to support composite keys we need to build it as WHERE ( (id1 = ? AND id2 = ?) OR (id1 = ? AND id2 = ?)) but this is currently not possible with the way how internally the $criteria array is used.

Show
Benjamin Eberlei added a comment - - edited Requirements for batching of eager loads: 1. Since we are using an IN() query for this we can only support this feature for entities that have a single column primary key. 2. If we want to support composite keys we need to build it as WHERE ( (id1 = ? AND id2 = ?) OR (id1 = ? AND id2 = ?)) but this is currently not possible with the way how internally the $criteria array is used.
Hide
Permalink
Benjamin Eberlei added a comment -

Next item to think about: What if an exception or event breaks the flow and "triggerEagerLoads()" is never called?

Show
Benjamin Eberlei added a comment - Next item to think about: What if an exception or event breaks the flow and "triggerEagerLoads()" is never called?
Benjamin Eberlei made changes -
Field Original Value New Value
Fix Version/s 2.x [ 10090 ]
Fix Version/s 2.1 [ 10022 ]
Benjamin Eberlei made changes -
Workflow jira [ 12257 ] jira-feedback [ 13895 ]
Benjamin Eberlei made changes -
Workflow jira-feedback [ 13895 ] jira-feedback2 [ 15759 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 15759 ] jira-feedback3 [ 18016 ]
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
  • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-952, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Benjamin Eberlei
Vote (0)
Watch (0)

Dates

  • Created:
    Updated: