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

print_category_info and so course/index.php calls 'select count(*) from mdl_course' multiple times rather than being passed to print_category_info

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 1.9.4, 1.9.5, 2.0
    • Fix Version/s: None
    • Component/s: General, Performance
    • Database:
      PostgreSQL
    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      Currently when you view course/index.php the print_category_info function is called for every category on the site.
      this function performs 'select count from mdl_course' every time it is called.

      This is not required and should ideally be passed as an argument to the function.
      this doesn't scale particularly well.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: