Issue Details (XML | Word | Printable)

Key: MDL-18290
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Martin Dougiamas
Reporter: Dan Poltawski
Votes: 1
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

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

Created: 18/Feb/09 12:07 AM   Updated: 18/Feb/09 12:12 AM
Return to search
Component/s: Forum, Performance
Affects Version/s: 1.9.4
Fix Version/s: None

Database: MySQL
Participants: Dan Poltawski and Martin Dougiamas
Security Level: None
Affected Branches: MOODLE_19_STABLE


 Description  « Hide
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


 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Dan Poltawski added a comment - 18/Feb/09 12:12 AM
forum_get_readable_forums() appears to be the problematic function