Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Not a bug
-
Affects Version/s: 1.7, 1.7.1, 1.7.2, 1.8
-
Fix Version/s: None
-
Component/s: Roles / Access
-
Labels:None
-
Affected Branches:MOODLE_17_STABLE, MOODLE_18_STABLE
Description
Time for connection to Moodle is too long for some users.
It depends, for some part, on the number of his courses. But it is not the only one reason... There is something other that I don't know...
My context:
- 34,000 users
- 700 courses
- 11 different roles
- 130 course categories and up to 6 levels of categories (nested categories)
- 43,000 records in mdl_roles_assignments
Linux 2.6.9-42.0.3.plus.c4smp + MySQL 4.1.20 + latest MOODLE_18_STABLE
Here are two contradictory examples:
1) Time for connecting teacher JosephR: 34 seconds
He is assigned as a teacher at 18 courses (included 5 courses not enrollable)
2) Time for connecting student MarcadeC: 8 seconds
She is assigned as a student at more than 20 courses
Arno
Issue Links
| This issue will help resolve: | ||||
| MDL-7416 | get_my_courses is very slow with lots of courses |
|
|
|
| MDL-9238 | Users assigned to a role at category-level don't view the courses of the subcategory |
|
|
|
| MDL-8149 | Profile page has incredibly poor performance when database contains many courses |
|
|
|
| This issue has been marked as being related by: | ||||
| MDL-8120 | Role override SQL retrieving extremely large combinatorial result set |
|
|
|
Activity
Hide
Arnaud saint-Georges
added a comment -
Hi Yu,
For my installation, that works fine now. Because of the resolution of bug MDL-9238.
I think you can close this bug. 
Arno
Show
Arnaud saint-Georges
added a comment - Hi Yu,
For my installation, that works fine now. Because of the resolution of bug MDL-9238.
I think you can close this bug. Arno
Arno 
Hi,
Is this 1.7 or 1.8? This bug is tagged as both 1.7, and 1.8. This issue regarding long log in time is solved in 1.8.
Cheers,
Yu