Hi One of the frequent queries that apear at the slow query logs is this one who runs from the course/search.php. Is there any index that can speed up this query ? or any customization ? Thank's in advance SELECT c.*, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel FROM mdl_course c JOIN mdl_context ctx ON (c.id = ctx.instanceid AND ctx.contextlevel=50) WHERE (( fullname LIKE '%discipline%' ) OR ( summary LIKE '%discipline%' ) OR ( idnumber LIKE '%discipline%' ) OR ( shortname LIKE '%discipline%' )) AND category > 0 ORDER BY fullname ASC;
Hardware and performance
Slow query on course search.php
This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.