Bug #9495
closed
increase timing stats table speed on large session
Added by Anchi Cheng about 4 years ago.
Updated about 4 years ago.
Affected Version:
Appion/Leginon 3.4
Description
The query creates a very large array of all times for all images. At 50k images, it is too much.
Reorganized the query to be done per preset and limit the timing calculation to the recent 1000 image.
Only preset between mean and between stdev use this query.
It improved the loading time of timing report for a session with total of 12k images from 45 seconds to 2.6 seconds. The stats between mean of enn is different by 0.2 seconds for a value that is 12.3, with between stdev at 12.4. It is good enough.
- Status changed from Assigned to Closed
Also available in: Atom
PDF