Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-6108

Cleanup instance.clid

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.2.0
    • Component/s: Technical / Transverse
    • Tags:
    • Story Points:
      2

      Description

      Instances CLID are all stored in the same folder; default-domain/connectRoot/instances folder; growing more and more which is today one of our slowest query.

      We don't need anymore most of the CLID, and an easy way to do increase performance would be to remove not used ones. When a CLID is used to access NOS; a metadata connectinstance:lastAccessDate is updated.

      We could leverage that field to delete CLID not accessed for 1 year.

      SELECT * FROM ConnectInstance WHERE connectinstance:lastAccessDate <= DATE '2019-09-30'
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: