[DDC-952] Several features to batch eager selects more efficently Created: 27/Dec/10  Updated: 11/Sep/13  Resolved: 11/Sep/13

Status: Resolved
Project: Doctrine 2 - ORM
Component/s: ORM
Affects Version/s: None
Fix Version/s: 2.2
Security Level: All

Type: New Feature Priority: Major
Reporter: Benjamin Eberlei Assignee: Benjamin Eberlei
Resolution: Fixed Votes: 1
Labels: None

Sub-Tasks:
Key
Summary
Type
Status
Assignee
DDC-733 Implement a way of forcing a Persiste... Sub-task Resolved Benjamin Eberlei  
DDC-734 Possibility to fetch all outstanding ... Sub-task Closed Guilherme Blanco  
DDC-53 Introduce batching of eager loads Sub-task Resolved Benjamin Eberlei  
DDC-914 Use JOIN for Fetch=EAGER ManyToOne an... Sub-task Resolved Benjamin Eberlei  
DDC-1060 Use Hydrators inside Persisters Sub-task Resolved Benjamin Eberlei  
DDC-963 @OneToOne inverse side executes queri... Sub-task Resolved Benjamin Eberlei  
DDC-865 Passing an array as parameter Sub-task Resolved Benjamin Eberlei  

 Description   

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



 Comments   
Comment by Benjamin Eberlei [ 31/Dec/10 ]

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.

Comment by Benjamin Eberlei [ 31/Dec/10 ]

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

Generated at Tue Jul 29 04:40:13 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.