Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-5365

Add index: mdl_turnitin_submissions.submissions_objectid

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 2.7
    • Module: Turnitintool
    • None
    • MOODLE_27_STABLE

      Turnitin is creating massive DB load in what looks to be its GC process. We see lots of deletes in the form of

      DELETE FROM mdl_turnitintool_submissions WHERE submission_objectid=457256626 AND submission_part=2807 
      

      which performs a full table scan. An index on submission_objectid solves the problem.

      It does not appear that turnitintwo has an index on submission_objectid.

            paul.dawson Paul Dawson (Inactive)
            ericbjella Eric Bjella
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.