Description
Valid Title
- I have updated the title to accurately reflect the bug description
Description
Due to a bug on how the metrics are retrieved, a home page with 10 preprints might take more than 2 minutes to be displayed.
A related bug is that the number of downloads displayed on the frontend will be the same for all preprints.
Steps to Reproduce
- Open the home page
Expected Result
It shouldn't take more than a couple of seconds to see the content.
Actual Result
It takes more than 2 minutes.
Environment Details
No response
Application Version
OPS 3.5
Logs
No response
Additional Information
Due to a bug on how the statistics are retrieved, the query against the metrics table ends up almost without filters.
There's also room for many optimizations on the code.
The problem was seen in the 3.5 release, but looks like it's also present on 3.4.
PRs:
stable-3_4_0: pkp/ops#954
stable-3_5_0:
main: