Inefficient SQL query for surl status checks

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • 1.11.8
    • Affects Version/s: 1.11.7
    • Component/s: backend
    • Security Level: Public (Visbile by non-authn users.)
    • None

      The query used to check if a SURL is pinned does not leverage the index built on the SURL hash value, resulting in all the rows being checked by MySQL to get the status of the SURL.

      This causes unnecessary high load on the MySQL server and slows down request handling

            Assignee:
            Unassigned
            Reporter:
            Andrea Ceccanti
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: