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 #1640 (closed)

Opened 14 years ago

Closed 14 years ago

Add index to Well.col and Well.row

Reported by: jamoore Owned by: jamoore
Priority: minor Milestone: OMERO-Beta4.2
Component: Model Version: 4.1
Keywords: n.a. Cc: cxallan
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: 0.0d
Sprint: 2010-06-24 (12)

Description

While testing with Bernhard, we saw a select max(w.column), max(w.row) taking not a huge amount of time, but more than expected. Adding indexes significantly sped things up.

Change History (5)

comment:1 Changed 14 years ago by jmoore

  • Component changed from General to Model

comment:2 Changed 14 years ago by jmoore

  • Sprint set to 2010-06-10 (11)

Adding to the current sprint to be considered.

comment:3 Changed 14 years ago by jburel

  • Sprint changed from 2010-06-10 (11) to 2010-06-24 (12)

comment:4 Changed 14 years ago by jmoore

  • Status changed from new to assigned

comment:5 Changed 14 years ago by jmoore

  • Remaining Time set to 0
  • Resolution set to fixed
  • Status changed from assigned to closed

(In [7344]) Various db fixes including well indices and naming conventions (Fix #1640, #2428)

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.69282 sec.)

© 2000-2014 University of Dundee & Open Microscopy Environment. Creative Commons Attribution 3.0 Unported License
OME source code is available under the GNU General public license or through commercial license from Glencoe Software

We're Hiring!