Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #1057 (new)

Opened 16 years ago

Last modified 14 years ago

SELECT N+1 issue with annotations and counts

Reported by: jamoore Owned by: jamoore
Priority: major Milestone: Unscheduled
Component: Performance Version: 3.0-M1
Keywords: hibernate, queries Cc: cxallan, jburel
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.


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:

        annotation0_.experimenter_id as experime1_0_,
        annotation0_.count as count0_,
        annotation0_.owner_id as owner3_0_ 
        count_Experimenter_annotationLinks_by_owner annotation0_ 

Change History (4)

comment:1 Changed 15 years ago by jmoore

  • Milestone changed from OMERO-Beta4 to OMERO-Beta4.1

Unclear on which methods we are running into this. Profiling will most likely be needed (including counting SQL statements). Pushing.

comment:2 Changed 15 years ago by jmoore

  • Milestone changed from OMERO-Beta4.1 to OMERO-Beta4.2

comment:3 Changed 14 years ago by jmoore

  • Milestone changed from OMERO-Beta4.2 to Unscheduled

comment:4 Changed 14 years ago by jmoore

Jean-Marie, would the use of IQuery.projection() help here?

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.63217 sec.)

We're Hiring!