Opened 8 years ago

Closed 8 years ago

#398 closed enhancement (fixed)

Add option to export the monthly operation list for a full year

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: Reggie v2.7
Component: net.sf.basedb.reggie Keywords:
Cc:

Description


Change History (2)

comment:1 Changed 8 years ago by Nicklas Nordborg

(In [1674]) References #398: Add option to export the monthly operation list for a full year

This should now work, but I'll make a few performance tests with more data just to check if something can be improved.

comment:2 Changed 8 years ago by Nicklas Nordborg

Resolution: fixed
Status: newclosed

(In [1676]) Fixes #398: Add option to export the monthly operation list for a full year

Show the 'working...' animation in the gui while the list is loading. The export now FETCH JOINS a few extra table to avoid n+1 select problems to a certain degree.

Annotation values are loaded with the SnapshotManager (see http://base.thep.lu.se/ticket/1374), which also helps a bit, but... the fix for the permission issue discovered recently (http://base.thep.lu.se/ticket/1685) seems to have negative impact since it requires 1 extra SQL statements per item and annotation loaded. Though this doesn't really matter for Reggie which still load data for a full year in just a few seconds it would be interesting to know how this impact the test scenarios used in BASE ticket 1374.

Note: See TracTickets for help on using tickets.