|
|
|
Issue Links:
|
Relates
|
|
This issue has a non-specific relationship to:
|
|
|
MDL-8789 Add a new flag field to the roles_assignments table to indicate if this enrolment is current (based on timeend/timestart)
|
|
|
|
|
|
This issue has been marked as being related by:
|
|
|
MDL-13240 Add timestart/timeend support back to permissions code
|
|
|
|
|
|
|
|
Eloy has correctly identified timestart and timeend as a big database bottleneck in load_user_capability because they prevent caching and deal with inequalities, so let's get rid if them!
These times specify the duration that the enrolment is active. Currently they are only used by self-enrolling courses where the course has a duration. In these instance timestart is set to now and timeend is set to some time in the future. Zero in timestart means inifinite past, and in timeend means inifinite future.
We were checking these to cope with all cases where people might want to set enrolment durations starting and ending in the future, but this is actually not very useful. Let's let the enrolment plugins handle such things (adding role assignments on the fly where necessary).
So instead, I propose:
1) We remove the time checks completely from load_user_capability and assume all role assigments in the database are valid.
2) We add a cron check to delete any role assignments where (timeend > 0 AND timeend < $now)
3) We make sure this is documented well in the code and on the wiki.
|
|
Description
|
Eloy has correctly identified timestart and timeend as a big database bottleneck in load_user_capability because they prevent caching and deal with inequalities, so let's get rid if them!
These times specify the duration that the enrolment is active. Currently they are only used by self-enrolling courses where the course has a duration. In these instance timestart is set to now and timeend is set to some time in the future. Zero in timestart means inifinite past, and in timeend means inifinite future.
We were checking these to cope with all cases where people might want to set enrolment durations starting and ending in the future, but this is actually not very useful. Let's let the enrolment plugins handle such things (adding role assignments on the fly where necessary).
So instead, I propose:
1) We remove the time checks completely from load_user_capability and assume all role assigments in the database are valid.
2) We add a cron check to delete any role assignments where (timeend > 0 AND timeend < $now)
3) We make sure this is documented well in the code and on the wiki. |
Show » |
moodler committed 2 files to 'Moodle CVS' on branch 'MOODLE_18_STABLE' - 07/Mar/07 01:54 PM
Fixes to remove timestart and timeend from consideration when loading user capabilities
Instead, we delete role assignments in cron
This is resulting in a great speed increase! MDL-8785
Thanks Eloy for the idea!
|
|
|
moodler committed 2 files to 'Moodle CVS' - 07/Mar/07 01:56 PM
Merged fixes for MDL-8785 from 1.8 to head
|
|
|
moodler committed 2 files to 'Moodle CVS' on branch 'MOODLE_17_STABLE' - 07/Mar/07 02:00 PM
Merged fixes for MDL-8785 from 1.8
BIG SPEED INCREASE!!!!!!
|
|
|
|