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

Course category tree on frontpage costs a db query per course

    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

        Gliffy Diagrams

          Issue Links

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: