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

Rendering page /my/courses.php takes 20s for no admin user

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 4.0.4
    • Blocks, Course, Performance
    • MOODLE_400_STABLE
    • MDL-75786-master
    • Hide

      Prerequisites:

      To reproduce the performance issue the following appear to be necessary:

      1. MUC is configured to use Redis caching.
      2. A large course category structure with lots of courses, e.g. 2K course categories, 25K courses.
      3. the logged in user has student level privileges. 

      Testing:

      1. Login a student.
      2. Ensure that loading my/courses.php takes more than several seconds.
      3. Apply this patch.
      4. Login as an administrator.
      5. Navigate to the MUC config and click 'rescan definitions'.
      6. Login as a student.
      7. Navigate to my/courses.php
      8. Check that page generation time is faster than in step 2.
      Show
      Prerequisites: To reproduce the performance issue the following appear to be necessary: MUC is configured to use Redis caching. A large course category structure with lots of courses, e.g. 2K course categories, 25K courses. the logged in user has student level privileges.  Testing: Login a student. Ensure that loading my/courses.php takes more than several seconds. Apply this patch. Login as an administrator. Navigate to the MUC config and click 'rescan definitions'. Login as a student. Navigate to my/courses.php Check that page generation time is faster than in step 2.

      Rendering page /my/courses.php takes 20s for no admin user.
      For user with admin rights it takes < 1s.
      My database is over 100GB.

      The problem is function get_all_children_ids() from /course/classes/category.php 

       

       

        1. 0001-MDL-75786-optimise-get_nearest_editable_subcategory.patch
          1 kB
        2. logs.png
          logs.png
          286 kB

            Unassigned Unassigned
            parsival7@gmail.com Daniel Marzec
            Votes:
            3 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:

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