Details
-
Type:
Bug
-
Status: CLOSED
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 19.3
-
Component/s: Rubrics
-
Labels:
-
19 status:Resolved
-
Conversion Script Required:Yes
-
Test Plan:
Description
Some rubrics SQL queries are missing indexes. Observed in slow query logs.
select toolitemru0_.id as id1_215_, toolitemru0_.itemId as itemId2_215_, toolitemru0_.created as created3_215_, toolitemru0_.creatorId as creatorI4_215_, toolitemru0_.modified as modified5_215_, toolitemru0_.ownerId as ownerId6_215_, toolitemru0_.ownerType as ownerTyp7_215_, toolitemru0_.shared as shared8_215_, toolitemru0_.rubric_id as rubric_i9_215_, toolitemru0_.toolId as toolId10_215_ from rbc_tool_item_rbc_assoc toolitemru0_ where toolitemru0_.toolId='sakai.gradebookng' and toolitemru0_.itemId='1145968' and (toolitemru0_.ownerId='ed5c6014-8980-4b0a-bf6c-2da3f86f69c0' or 1=0) select evaluation0_.id as id1_211_, evaluation0_.evaluated_item_id as evaluate2_211_, evaluation0_.evaluated_item_owner_id as evaluate3_211_, evaluation0_.evaluator_id as evaluato4_211_, evaluation0_.created as created5_211_, evaluation0_.creatorId as creatorI6_211_, evaluation0_.modified as modified7_211_, evaluation0_.ownerId as ownerId8_211_, evaluation0_.ownerType as ownerTyp9_211_, evaluation0_.shared as shared10_211_, evaluation0_.overallComment as overall11_211_, evaluation0_.association_id as associa12_211_ from rbc_evaluation evaluation0_ where evaluation0_.ownerId='d669b3bd-ef1c-4b62-bb36-88b0edf18e97' or 1=0 limit 20
Gliffy Diagrams
Zeplin
Attachments
Issue Links
- is related to
-
SAK-44753 Rubrics tool association add a unique constraint per rubric / tool / item
-
- Verified
-