Details
-
Type:
(Deprecated) Contributed Patch
-
Status: CLOSED
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.9.0
-
Component/s: Forums Tool
-
Labels:None
-
Environment:Mysql 5.1
-
Previous Issue Keys:MSGCNTR-791
Description
MSGCNTR-403 added forum statistics and grading
Occasionally, we see slow queries in MySQL because a bad query plan is chosen. MySQL uses the primary index instead of the much better secondary index. One possible reason is that the ORDER BY clauses in findReadMessagesForStudent causes query plan confusion.
The order by is completely unnecessary as the sorting is already done in Java code (messageforums-app/src/java/org/sakaiproject/tool/messageforums/ui/MessageForumStatisticsBean.java):
sortStatisticsByUser2(statistics);
Gliffy Diagrams
Zeplin
Attachments
Issue Links
- relates to
-
SAK-24785 Grading Forums - Easier way to view all messages from one person and enter grade in one screen, or view list of all users with counts of posts and grade entry box
-
- CLOSED
-