Task #1057 (new)
SELECT N+1 issue with annotations and counts
|Reported by:||jamoore||Owned by:||jamoore|
|Keywords:||hibernate, queries||Cc:||cxallan, jburel|
Like with annotations (#1047), queries over over experimenters join the count values one entity at a time, resulting in N+1 hits to the database, with N of the form:
select annotation0_.experimenter_id as experime1_0_, annotation0_.count as count0_, annotation0_.owner_id as owner3_0_ from count_Experimenter_annotationLinks_by_owner annotation0_ where annotation0_.experimenter_id=?