Inefficient query used to update SURL status when a releaseFiles is called

XMLWordPrintable

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

      The query used to update the status of a list of SURLs after a releaseFiles operation does not leverage the index built on the SURL hash value, resulting in unnecessary high load on the MySQL server which slows down request handling.

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

              Created:
              Updated:
              Resolved: