Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-21758

Improve DBS getLastVersion performance

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 8.10
    • Fix Version/s: QualifiedToSchedule
    • Component/s: Core

      Description

      The actual implementation list all versions, sort by version created date then it returns the most recent.

      This does not scale for document having > 500 versions.
      Instead of fetching all versions state, a query should be done, either by retrieving the first document order by version date desc or by using the IS_LATEST_DOCUMENT

      org.nuxeo.ecm.core.storage.dbs.DBSSession#getLastVersion

        Attachments

          Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. NXP-21759 Make ecm:isLatestVersion an optional feature

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                bdelbosc Benoit Delbosc
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: