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

Improve external database enrolment sync performance by running sync in parallel

    XMLWordPrintable

Details

    • Improvement
    • Status: Development in progress
    • Minor
    • Resolution: Unresolved
    • Future Dev
    • None
    • Enrolments

    Description

      On a big instances (e.g. a university in the begging of a semester) a huge number of enrolment activities can run for a long time. 

      For example recently we've seen following:

      • new enrolment - 144 359 events
      • re-enrolling - 1 175 events
      • assigning new roles - 2 233 events
      • un-assigning roles - 1 079 events

      This took more that 12 hours.

      We propose rather than run all those events in one long running task split them into many adhoc tasks and run in parallel.

      Could be individual tasks or better batches like 100 or 1000 events per adhoc task. 

      Attachments

        Issue Links

          Activity

            People

              tomotsuyuki Tomo Tsuyuki
              dmitriim Dmitrii Metelkin
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: