Assistance technique

Très bien, mais je vous annonce que je n'aurai pas besoin d'en installer un.

Le problème dans mon développement (conjointement avec Olivier CATTEAU), c'était le role_assign qui, exécuté dans une boucle, ralentissait considérablement les perfs de mysql.

PROBLEME RESOLU :
j'ai simplement redéfini la fonction role assign qui était :

function role_assign($roleid, $userid, $groupid, $contextid, $timestart=0, $timeend=0, $hidden=0, $enrol='manual',$timemodified='') { global $USER, $CFG; /// Do some data validation if (empty($roleid)) { debugging('Role ID not provided'); return false; } if (empty($userid) && empty($groupid)) { debugging('Either userid or groupid must be provided'); return false; } if ($userid && !record_exists('user', 'id', $userid)) { debugging('User ID '.intval($userid).' does not exist!'); return false; } if ($groupid && !groups_group_exists($groupid)) { debugging('Group ID '.intval($groupid).' does not exist!'); return false; } if (!$context = get_context_instance_by_id($contextid)) { debugging('Context ID '.intval($contextid).' does not exist!'); return false; } if (($timestart and $timeend) and ($timestart > $timeend)) { debugging('The end time can not be earlier than the start time'); return false; } if (!$timemodified) { $timemodified = time(); } /// Check for existing entry if ($userid) { $ra = get_record('role_assignments', 'roleid', $roleid, 'contextid', $context->id, 'userid', $userid); } else { $ra = get_record('role_assignments', 'roleid', $roleid, 'contextid', $context->id, 'groupid', $groupid); } $newra = new object; if (empty($ra)) { // Create a new entry $newra->roleid = $roleid; $newra->contextid = $context->id; $newra->userid = $userid; $newra->hidden = $hidden; $newra->enrol = $enrol; /// Always round timestart downto 100 secs to help DBs to use their own caching algorithms /// by repeating queries with the same exact parameters in a 100 secs time window $newra->timestart = round($timestart, -2); $newra->timeend = $timeend; $newra->timemodified = $timemodified; $newra->modifierid = empty($USER->id) ? 0 : $USER->id; $success = insert_record('role_assignments', $newra); } else { // We already have one, just update it $newra->id = $ra->id; $newra->hidden = $hidden; $newra->enrol = $enrol; /// Always round timestart downto 100 secs to help DBs to use their own caching algorithms /// by repeating queries with the same exact parameters in a 100 secs time window $newra->timestart = round($timestart, -2); $newra->timeend = $timeend; $newra->timemodified = $timemodified; $newra->modifierid = empty($USER->id) ? 0 : $USER->id; $success = update_record('role_assignments', $newra); } if ($success) { /// Role was assigned, so do some other things /// mark context as dirty - modules might use has_capability() in xxx_role_assing() /// again expensive, but needed mark_context_dirty($context->path); if (!empty($USER->id) && $USER->id == $userid) { /// If the user is the current user, then do full reload of capabilities too. load_all_capabilities(); } /// Ask all the modules if anything needs to be done for this user if ($mods = get_list_of_plugins('mod')) { foreach ($mods as $mod) { include_once($CFG->dirroot.'/mod/'.$mod.'/lib.php'); $functionname = $mod.'_role_assign'; if (function_exists($functionname)) { $functionname($userid, $context, $roleid); } } } } /// now handle metacourse role assignments if in course context if ($success and $context->contextlevel == CONTEXT_COURSE) { if ($parents = get_records('course_meta', 'child_course', $context->instanceid)) { foreach ($parents as $parent) { sync_metacourse($parent->parent_course); } } } return $success; }

par :

function role_assign_iut($roleid, $userid, $groupid, $contextid, $timestart=0, $timeend=0, $hidden=0, $enrol='manual',$timemodified=''){ global $USER, $CFG; if (!$timemodified) { $timemodified = time(); } $newra = new object; $ra = get_record('role_assignments', 'roleid', $roleid, 'contextid', $contextid, 'userid', $userid); if (empty($ra)) { // Create a new entry $newra->roleid = $roleid; $newra->contextid = $contextid; $newra->userid = $userid; $newra->hidden = $hidden; $newra->enrol = $enrol; /// Always round timestart downto 100 secs to help DBs to use their own caching algorithms /// by repeating queries with the same exact parameters in a 100 secs time window $newra->timestart = round($timestart, -2); $newra->timeend = $timeend; $newra->timemodified = $timemodified; $newra->modifierid = empty($USER->id) ? 0 : $USER->id; $success = insert_record('role_assignments', $newra); } else { // We already have one, just update it $newra->id = $ra->id; $newra->hidden = $hidden; $newra->enrol = $enrol; /// Always round timestart downto 100 secs to help DBs to use their own caching algorithms /// by repeating queries with the same exact parameters in a 100 secs time window $newra->timestart = round($timestart, -2); $newra->timeend = $timeend; $newra->timemodified = $timemodified; $newra->modifierid = empty($USER->id) ? 0 : $USER->id; $success = update_record('role_assignments', $newra); } if ($success) { /// Role was assigned, so do some other things /// mark context as dirty - modules might use has_capability() in xxx_role_assing() /// again expensive, but needed mark_context_dirty($context->path); if (!empty($USER->id) && $USER->id == $userid) { /// If the user is the current user, then do full reload of capabilities too. load_all_capabilities(); } /// Ask all the modules if anything needs to be done for this user if ($mods = get_list_of_plugins('mod')) { foreach ($mods as $mod) { include_once($CFG->dirroot.'/mod/'.$mod.'/lib.php'); $functionname = $mod.'_role_assign'; if (function_exists($functionname)) { $functionname($userid, $context, $roleid); } } } } /// now handle metacourse role assignments if in course context if ($success and $context->contextlevel == CONTEXT_COURSE) { if ($parents = get_records('course_meta', 'child_course', $context->instanceid)) { foreach ($parents as $parent) { sync_metacourse($parent->parent_course); } } } return $success; }

EDIT : Oups, ça fait un post un peu long... ^_^'

Car : J'effectue toutes les vérifications des variables (les 5 ou 6 premiers "if") en dehors de la boucle des role_assign, dans la boucle, le "context" ne change pas, ni le "roleid", ni le "groupid", seulement le userid.

Voilà, problème résolu.

Rendez-vous à la moodlemoot pour vous expliquer tout ça en profondeur...

PS : mon temps d'exécution pour le même jeu de tests qu'avant est passé en dessous des 2 secondes.... soit grâce à cette mofification, mon script est 100 fois plus rapide... que dire?