Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-42700

Rubrics observed slow queries without indexes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 19.3
    • Fix Version/s: 19.6, 20.0
    • Component/s: Rubrics
    • Labels:
    • 19 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      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

                Activity

                  People

                  Assignee:
                  ottenhoff Sam Ottenhoff
                  Reporter:
                  ottenhoff Sam Ottenhoff
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration