Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 1.9.11
-
Fix Version/s: None
-
Component/s: Module: HotPot
-
Labels:None
-
Affected Branches:MOODLE_19_STABLE
Description
Eloy spotted this query that might need some optimization
3) SELECT
h.id AS id,
h.name AS name,
COUNT
AS count_attempts
FROM
hotpot h,
hotpot_attempts a
WHERE
h.course = 34
AND h.id = a.hotpot
AND a.id = a.clickreportid
AND a.starttime > 1187805492
GROUP BY
h.id, h.name;
(not really often but happens)
Issue Links
| This issue has a non-specific relationship to: | ||||
| MDL-10990 | Try to improve some queries no using indexes... |
|
|
|
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
