Opened 12 years ago
Closed 12 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 by , 12 years ago
comment:2 by , 12 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
(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.
(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.