Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-58016

Performance issue in grade history cleanup (implement TODO)

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 3.1.4, 3.2.1, 3.3
    • Gradebook

      As of now, if gradehistorylifetime is set, the grade history tables are getting pruned every cron run. This may be a performance issue when huge tables (e,g. 10 or 20 million rows) are getting pruned every 5 minutes. There's a TODO comment in code in this regard, which looks as follows:

      //TODO: do not run this cleanup every cron invocation
      

      I suggest that this be re-done as a nightly "cleanup" scheduled task.
      Will provide with a code change when completed.

            badblock Kirill Astashov
            badblock Kirill Astashov
            Ankit Agarwal Ankit Agarwal
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.