Moodle

/mod/assignment/index.php slow loading - excessive queries

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.8
  • Fix Version/s: None
  • Component/s: Assignment (2.2)
  • Labels:
    None
  • Environment:
    Ubuntu 6.06 (Linux 2.6.15-28-386), Apache 2.0.55, MySQL 5.0.22, PHP 5.1.2. with APC 3.0.14
  • Affected Branches:
    MOODLE_18_STABLE

Description

Since upgrading from 1.6 to 1.8 loading the assignment page for my course takes an excessive amount of time. Performance info for loading the page is:
121.342788 secs RAM: 2.1MB Included 53 files DB queries 2211 Log writes 1 ticks: 12135 user: 7371 sys: 40 cuser: 0 csys: 0 Load average: 1.59 Record cache hit/miss ratio : 0/0
Let me know what steps you would like for me to take to test and/or help debug this. I'm a little new at diving into the logs but I'm willing to put some time in to help get to the bottom of this. There seem to be a few places where performance has really taken a hit. Would it be helpful to create a meta-bug to link together these performance related issues?

Activity

Hide
Alex Djachenko added a comment -

The same problem.
At processing request (by the "top" utility), working webserver (loading on a database small).

Perfomance log:
112.765661 secs RAM: 8.4????? Included 46 files ticks: 11277 user: 9577 sys: 25 cuser: 0 csys: 0 Load average: 0.95 Record cache hit/miss ratio : 0/0

Page info:
url: mod/assignment/index.php?id=xx
Assigments: 7
Answers: approximately 80 in each assigment.
Students on course: 384

Show
Alex Djachenko added a comment - The same problem. At processing request (by the "top" utility), working webserver (loading on a database small). Perfomance log: 112.765661 secs RAM: 8.4????? Included 46 files ticks: 11277 user: 9577 sys: 25 cuser: 0 csys: 0 Load average: 0.95 Record cache hit/miss ratio : 0/0 Page info: url: mod/assignment/index.php?id=xx Assigments: 7 Answers: approximately 80 in each assigment. Students on course: 384
Hide
Wen Hao Chuang added a comment -

Anothony I agree it's a good idea to create a meta-bug to link together these performance related issues. Are you also encountering slow loading and excessive queries when you switch between course categories when loaded with large number of courses? thanks

Show
Wen Hao Chuang added a comment - Anothony I agree it's a good idea to create a meta-bug to link together these performance related issues. Are you also encountering slow loading and excessive queries when you switch between course categories when loaded with large number of courses? thanks
Hide
Alex Djachenko added a comment -

No, on my system categories loading quickli: 0.2-0.5 secs

Show
Alex Djachenko added a comment - No, on my system categories loading quickli: 0.2-0.5 secs
Hide
Anthony Borrow added a comment -

This only seems to impact the course if it was upgraded from 1.6 to 1.8. I am not seeing the performance hit with a fresh install and then restoring a course. Of course the restored course was without student data so it may have something to do with the assignment submissions table.

Show
Anthony Borrow added a comment - This only seems to impact the course if it was upgraded from 1.6 to 1.8. I am not seeing the performance hit with a fresh install and then restoring a course. Of course the restored course was without student data so it may have something to do with the assignment submissions table.
Hide
Anthony Borrow added a comment -

There were a variety of performance improvements in 1.8 since this was filed. At this point, I am unable to reproduce the problem and it seems obsolete. I'm going to resolve this as fixed; however, if anyone is still experiencing difficulty with the page loading extremely slowly let me know and we can re-open and investigate.

Show
Anthony Borrow added a comment - There were a variety of performance improvements in 1.8 since this was filed. At this point, I am unable to reproduce the problem and it seems obsolete. I'm going to resolve this as fixed; however, if anyone is still experiencing difficulty with the page loading extremely slowly let me know and we can re-open and investigate.
Hide
Anthony Borrow added a comment -

Just noting that some further (possibly related) improvements were made in MDL-18241

Show
Anthony Borrow added a comment - Just noting that some further (possibly related) improvements were made in MDL-18241

People

Vote (3)
Watch (4)

Dates

  • Created:
    Updated:
    Resolved: