Back porting to 1.10.x: N+1 select issue with Obs and ObsGroup -

TRUNK-4141
openmrs · Dec 5, 2013 · bbae7bf · bbae7bf
1 parent a0a573f
commit bbae7bf
Show file tree

Hide file tree

Showing 2 changed files with 2 additions and 2 deletions.
diff --git a/api/src/main/resources/org/openmrs/api/db/hibernate/Encounter.hbm.xml b/api/src/main/resources/org/openmrs/api/db/hibernate/Encounter.hbm.xml
@@ -54,7 +54,7 @@
 			<one-to-many class="Order" />
 		</set>
 		<!-- bi-directional one-to-many association to Ob -->
-		<set name="obs" inverse="true" cascade="all" order-by="concept_id" access="field">
+		<set name="obs" inverse="true" cascade="all" order-by="concept_id" access="field" batch-size="25">
 			<key column="encounter_id" />
 			<one-to-many class="Obs" />
 		</set>

diff --git a/api/src/main/resources/org/openmrs/api/db/hibernate/Obs.hbm.xml b/api/src/main/resources/org/openmrs/api/db/hibernate/Obs.hbm.xml
@@ -70,7 +70,7 @@
 
 		<!-- one-to-many association to all obs in this grouping -->
 		<set name="groupMembers" inverse="true" cascade="all" order-by="obs_id"
-		access = "field">
+		access = "field" batch-size="25">
 			<key column="obs_group_id" />
 			<one-to-many class="Obs" />
 		</set>