Moodle

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

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Critical Critical
  • Resolution: Unresolved
  • 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

Activity

Hide
Dan Poltawski added a comment -

forum_get_readable_forums() appears to be the problematic function

Show
Dan Poltawski added a comment - forum_get_readable_forums() appears to be the problematic function

People

Vote (1)
Watch (0)

Dates

  • Created:
    Updated: