Uploaded image for project: 'Contrib: TurnItIn'
  1. Contrib: TurnItIn
  2. TII-150

missing index on contentreview-item

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.8
    • Fix Version/s: 0.9
    • Component/s: Service
    • Labels:
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      SAK-23776

      Description

      Maybe we missed a script somewhere, but our CONTENTREVIEW_ITEM wasn't indexed on contentId.

      Displaying Assignment 2 summary for 172 students took a full minute. Most of that was queries looking up the Turnitin score, which was done by a select on CONTENTREVIEW_ITEM by contentId.

      Indexing the table took the minute down to 4 sec.

      It would actually be better to fetch all the scores for that task at once rather than querying student by student. There's also a REALM query once per student. I can't tell what it's doing. The query is the same each time (i.e. it doesn't depend upon the student).

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ern Earle R Nietzel
                Reporter:
                hedrick Charles Hedrick
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code