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

Opened 13 years ago

Closed 13 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 13 years ago by cxallan

  • Status changed from new to accepted

comment:2 Changed 13 years ago by cxallan

  • Status changed from accepted to new

comment:3 Changed 13 years ago by cxallan

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

comment:4 Changed 13 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.69808 sec.)

We're Hiring!