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

Slow query from selecting LABEL and ENTRY FROM SAM_PUBLISHEDMETADATA_T

    XMLWordPrintable

    Details

    • 11 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      SAM-3040

      Description

      Observed monitoring MySQL slow query logs. Need an index on LABEL and ENTRY

      select publisheda0_.*
      from SAM_PUBLISHEDASSESSMENT_T publisheda0_
      inner join SAM_PUBLISHEDMETADATA_T publishedm1_
      where publisheda0_.ID=publishedm1_.ASSESSMENTID and publishedm1_.LABEL='ALIAS'
      and publishedm1_.ENTRY='0c7e6eb0-1d8b-448d-8550-f4260aa52b821474912340152';

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code