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

          Zeplin

            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 Integration