Actions
Bug #9495
closedincrease timing stats table speed on large session
Start date:
11/02/2020
Due date:
% Done:
0%
Estimated time:
Affected Version:
Appion/Leginon 3.4
Show in known bugs:
No
Workaround:
Description
The query creates a very large array of all times for all images. At 50k images, it is too much.
Updated by Anchi Cheng over 3 years ago
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.
Actions