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

          Zeplin

            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 Integration