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

Opened 16 years ago

Closed 16 years ago

Improve Thumbnail Performance

Reported by: cxallan Owned by: cxallan
Priority: critical Milestone: 3.0-Beta3.1
Component: Bin-Services Version: n.a.
Keywords: n.a. Cc: jburel, jamoore
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

The thumbnail performance in milestone:3.0-Beta3.0 is quite degraded; partially due to #1047 but mainly because of non-intelligent database querying.

Change History (6)

comment:1 Changed 16 years ago by cxallan

  • Status changed from new to assigned

comment:2 Changed 16 years ago by cxallan

  • Cc jmoore added

#2662 implements the following improvements:

  • Shallow retrieval throughout to reduce database overhead for cached thumbnails
  • Bulk retrieval for bulk thumbnail methods (getThumbnailSet() and getThumbnailByLongestSideSet())
  • Deferred renderer creation
  • Cleanups to data retrieval hierarchy
  • Moved certain log messages into DEBUG
  • Cached enumeration retrieval (single set of enumeration retrievals per thumbnail bean instance)

comment:3 Changed 16 years ago by cxallan

Sorry r2662.

comment:4 Changed 16 years ago by jmoore

See r2678 for a possible solution to the flushing issue in getThumbnailSet. If iupdate.commit() interferes with other logic in the other methods, then probably the only solution is to use SessionFactory directly and manage the session yourself (barring the Executor).

comment:5 Changed 16 years ago by cxallan

r2789 should now make this about as fast as we're going to get it without a lot more work.

comment:6 Changed 16 years ago by cxallan

  • Resolution set to fixed
  • Status changed from assigned to closed

All the multi-100ms problems have now been resolved. Difficult tasks still remain that could increase performance:

  • Server-side in memory caching
  • Thumbnail state cache that is database ignorant
  • Various I/O pooling techniques
  • etc.

Closing until a time at which it's deemed we need to take this to the next level.

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

We're Hiring!