DDC-952: Several features to batch eager selects more efficently #1187

Closed
opened 2026-01-22 13:05:21 +01:00 by admin · 3 comments
Owner

Originally created by @doctrinebot on GitHub (Dec 27, 2010).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @beberlei:

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

Originally created by @doctrinebot on GitHub (Dec 27, 2010). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @beberlei: This ticket aggregates several strategies to optimize batching of eager selects.
admin added the New Feature label 2026-01-22 13:05:21 +01:00
admin closed this issue 2026-01-22 13:05:23 +01:00
Author
Owner

@doctrinebot commented on GitHub (Dec 31, 2010):

Comment created by @beberlei:

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.
@doctrinebot commented on GitHub (Dec 31, 2010): Comment created by @beberlei: 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.
Author
Owner

@doctrinebot commented on GitHub (Dec 31, 2010):

Comment created by @beberlei:

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

@doctrinebot commented on GitHub (Dec 31, 2010): Comment created by @beberlei: Next item to think about: What if an exception or event breaks the flow and "triggerEagerLoads()" is never called?
Author
Owner

@doctrinebot commented on GitHub (Sep 11, 2013):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Sep 11, 2013): Issue was closed with resolution "Fixed"
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#1187