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

VCS: improve path-based search performance

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.2 GA
    • Fix Version/s: 5.3 RC
    • Component/s: Core VCS
    • Tags:
    • Impact type:
      Configuration format change
    • Upgrade notes:
      Hide

      For PostgreSQL, it's possible to disable the path-based optimizations by adding:
      <pathOptimizations enabled="true"/>
      in the default-repository-config.xml file (or similar).

      Show
      For PostgreSQL, it's possible to disable the path-based optimizations by adding: <pathOptimizations enabled="true"/> in the default-repository-config.xml file (or similar).

      Description

      VCS searches involving ecm:path STARTSWITH need to call the NX_IN_TREE stored procedure, which is costly on a large number of documents.
      This should be replaced by the use of a specialized "descendants" table holding all (document id, descendant id) couples, maintained using triggers.

        Attachments

          Activity

            People

            • Assignee:
              fguillaume Florent Guillaume
              Reporter:
              fguillaume Florent Guillaume
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4 days, 4 hours
                4d 4h
                Remaining:
                Remaining Estimate - 4 days, 4 hours
                4d 4h
                Logged:
                Time Spent - Not Specified
                Not Specified