Moodle

stats cron way too slow - rewrite using pure SQL

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.9
  • Fix Version/s: 1.9
  • Component/s: Administration
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_19_STABLE

Description

at present moodle.org stats either run out of memory or take hours to complete
target time for one day: < 20s

Issue Links

Activity

Hide
Petr Škoda (skodak) added a comment -

Tested with data from other large site.

Conclusions:
1/ the time needed to process one day depends on the activity during that day == no activity means <1 s per day, days with lots of logged data may take several minutes.
2/ performance depends on database server only => the faster the database server, the faster the processing

TODO:
a/ test with other databases
b/ review code logic

Show
Petr Škoda (skodak) added a comment - Tested with data from other large site. Conclusions: 1/ the time needed to process one day depends on the activity during that day == no activity means <1 s per day, days with lots of logged data may take several minutes. 2/ performance depends on database server only => the faster the database server, the faster the processing TODO: a/ test with other databases b/ review code logic
Hide
Petr Škoda (skodak) added a comment -

done

Show
Petr Škoda (skodak) added a comment - done

People

Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: