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

Improve delete speed for databases without path optims

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.0
    • Fix Version/s: 6.0-HF21, 7.10
    • Component/s: Core VCS

      Description

      When deleting a document/folder we need to find the ids of all descendant documents in order to invalidate them and clean caches.

      However when path optimizations are not enabled, this requires a full scan of the database and execution of NX_IN_TREE on each of them, which is very costly. Instead, we can do an iterative child traversal starting from the deleted document to find the descendants depth by depth. This will be must faster.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: