Affects Version/s: 3.7.7, 3.8.4, 3.9.4, 3.10.1
Fix Version/s: None
Affected Branches:MOODLE_310_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
A timeout and poor performance is still encountered on Moodle User Report Logs. This happens on Site-wide log report and course with large number of enrolled users/lots of activities.
Example for site-wide report log: total mdl_logstore_standard_log records = 1,863,847,613 (Postgresql 11.7 version) another site with total of 196,823,363 (Postgresql 9.6.12) gives timeout error when viewing the site logs.
Going to Site administration / Reports / Logs and displaying all the dates report result into time out.
Example for course report log where timeout is also experienced.
- Timeout was increased on load balancer but did not fixed the issue.
- Code fix from
MDL-52482and/or MDL-44998did not fixed the issue.