Moodle

course/index.php v.expensive

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Cannot Reproduce
  • Affects Version/s: 1.9.4
  • Fix Version/s: None
  • Component/s: Performance
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE

Description

Looking at our performance logs this page is averaging a thousand dbq a time, the max seen is 2615,

I started looking around - stopping get_categories() from doing anything removes 1299dbq - so I suspect something needs improving just with that. Taking out rebuild_course_cache removes the majority of the remaining queries.

Need to investigate and fix

Activity

Hide
Michael de Raadt added a comment -

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

Show
Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: