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

Opened 9 years ago

Closed 9 years ago

Better handling of large tables

Reported by: cxallan Owned by: cxallan
Priority: minor Milestone: OMERO-Beta4.3
Component: Insight Version: n.a.
Keywords: n.a. Cc: jburel, jamoore, jrswedlow
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: 0.0d
Sprint: 2010-12-23 (2)

Description

We now have some data for which there are 1Million or more rows per table and thousands of ROI per image. Insight currently chokes horribly on this type of data.

Change History (4)

comment:1 Changed 9 years ago by cxallan

  • Status changed from new to accepted

comment:2 Changed 9 years ago by cxallan

  • Status changed from accepted to new

comment:3 Changed 9 years ago by cxallan

  • Owner changed from jburel to cxallan
  • Status changed from new to assigned

comment:4 Changed 9 years ago by cxallan

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

(In [7860/insight]) Handle very large tables by page / row. (Fixes #3702)

Various additions:

  • Table translation creation using slice() paging (avoids Ice exceptions)
  • Table translation by "Image" lookup (avoids loading the whole table)
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.88381 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!