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

mod/forum/user.php taking 10226 DB queries on pageload

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 1.9.4
    • Fix Version/s: None
    • Component/s: Forum, Performance
    • Labels:
      None
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      When an admin is viewing a users forum posts (of which they've made 1 post) it is costing 10,000 queries.

      We should find out what is causing this and prevent it from happening.

      [Tue Feb 17 15:01:55 2009] [error] [client 192.168.254.2] PERF: /mod/forum/user.php?id=20172&course=1 time: 3.149196s memory_total: 28657060B (27.3MB) memory_growth: 28342728B (27MB) memory_peak: 35842756B (34.2MB) includecount: 88 dbqueries: 10225 logwrites: 1 ticks: 315 user: 234 sys: 14 cuser: 0 csys: 0 serverload: 0.10 rcache: 0/4

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            poltawski Dan Poltawski added a comment -

            forum_get_readable_forums() appears to be the problematic function

            Show
            poltawski Dan Poltawski added a comment - forum_get_readable_forums() appears to be the problematic function
            Hide
            salvetore 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.3 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

            Michael d;

            4d6f6f646c6521

            Show
            salvetore 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.3 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; 4d6f6f646c6521
            Hide
            salvetore Michael de Raadt added a comment -

            I'm closing this issue as it has been inactive for over a year has been recorded as affecting versions that are no longer supported.

            If you still believe this is an issue in supported versions, please report a new issue.

            Show
            salvetore Michael de Raadt added a comment - I'm closing this issue as it has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you still believe this is an issue in supported versions, please report a new issue.

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: