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

Course category tree on frontpage costs a db query per course

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.1.1, 2.7
    • Fix Version/s: BACKEND
    • Component/s: Performance
    • Labels:

      Description

      If the course category tree is used it costs a db query per course, this come from lots of enrol queries generated from the call to:

      enrol_get_course_info_icons()

      in course/renderer.php function course_category_tree_category()

      This means that page doesn't scale well if the site has thousands of courses

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              poltawski Dan Poltawski
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: