Moodle

Listing potential members in groups takes a long time

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.8.2
  • Fix Version/s: 1.9
  • Component/s: Groups
  • Labels:
    None
  • Environment:
    moodle-1.8.2+ apache-2.2 php-5.2 mysql-5.0.32
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_18_STABLE
  • Fixed Branches:
    MOODLE_19_STABLE

Description

Displaying a list o potential members in group after pressing Add/remove users takes a long time and database is heavy loaded.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Nick Freear added a comment -

Hi Dariusz,
A quick test on my developer install (PostgreSQL 8, PHP 5, Apache 2) shows it to be quite quick - pgAdmin doesn't have time to display database activity or locks. How many people in your courses and groups? Also, what performance data are you getting?

http://XXXX.open.ac.uk/head/group/members.php?group=1 # Head 2 # WC101 # Participants # Groups # Add/remove users, I get:
" 0.156641 secs
...
DB queries 20
ticks: 16 user: 13 sys: 0 cuser: 0 csys: 0
Load average: 0.39
..."

Any ideas Petr?
Many thanks

Nick

Show
Nick Freear added a comment - Hi Dariusz, A quick test on my developer install (PostgreSQL 8, PHP 5, Apache 2) shows it to be quite quick - pgAdmin doesn't have time to display database activity or locks. How many people in your courses and groups? Also, what performance data are you getting? http://XXXX.open.ac.uk/head/group/members.php?group=1 # Head 2 # WC101 # Participants # Groups # Add/remove users, I get: " 0.156641 secs ... DB queries 20 ticks: 16 user: 13 sys: 0 cuser: 0 csys: 0 Load average: 0.39 ..." Any ideas Petr? Many thanks Nick
Hide
Permalink
Dariusz Górka added a comment -

10 groups, 121 users in a course, 2524 users in a installation

27.848414 secs
RAM: 22.1Mb
Included 40 files
ticks: 2785 user: 37 sys: 5 cuser: 0 csys: 0
Load average: 0.65
Record cache hit/miss ratio : 360/125

But now I noticed that it works so slow only for the first time, next views are much more faster:

0.50227 secs
RAM: 22Mb
Included 40 files
ticks: 51 user: 39 sys: 5 cuser: 0 csys: 0
Load average: 0.22
Record cache hit/miss ratio : 360/125

Show
Dariusz Górka added a comment - 10 groups, 121 users in a course, 2524 users in a installation 27.848414 secs RAM: 22.1Mb Included 40 files ticks: 2785 user: 37 sys: 5 cuser: 0 csys: 0 Load average: 0.65 Record cache hit/miss ratio : 360/125 But now I noticed that it works so slow only for the first time, next views are much more faster: 0.50227 secs RAM: 22Mb Included 40 files ticks: 51 user: 39 sys: 5 cuser: 0 csys: 0 Load average: 0.22 Record cache hit/miss ratio : 360/125
Hide
Permalink
Petr Škoda (skodak) added a comment -

Could you please test the latest 1.9dev from cvs? The groups code was reimplemented in 1.9.

Show
Petr Škoda (skodak) added a comment - Could you please test the latest 1.9dev from cvs? The groups code was reimplemented in 1.9.
Hide
Permalink
Geoff King added a comment -

I can reproduce this problem on our Moodle 1.8.3 installation.
On our 1.9 testing installation there is no performance problem.

Show
Geoff King added a comment - I can reproduce this problem on our Moodle 1.8.3 installation. On our 1.9 testing installation there is no performance problem.
Hide
Permalink
Chris Bandy added a comment -

I can also confirm slow page loads in 1.8.4. Most of the functions appear to be internal to Groups; any chance of a backport from 1.9?

See also, http://moodle.org/mod/forum/discuss.php?d=79774

Show
Chris Bandy added a comment - I can also confirm slow page loads in 1.8.4. Most of the functions appear to be internal to Groups; any chance of a backport from 1.9? See also, http://moodle.org/mod/forum/discuss.php?d=79774
Hide
Permalink
Petr Škoda (skodak) added a comment -

The group internals are completely rewritten, no way to backport the code easily, sorry.

Show
Petr Škoda (skodak) added a comment - The group internals are completely rewritten, no way to backport the code easily, sorry.
Hide
Permalink
Petr Škoda (skodak) added a comment -

1.9 is out, closing as fixed
please reopen if you find similar problem in 1.9

thanks for the report

Show
Petr Škoda (skodak) added a comment - 1.9 is out, closing as fixed please reopen if you find similar problem in 1.9 thanks for the report

People

Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.