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

Optimize ancestors table initial creation when activating path optims

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.4
    • Component/s: Core VCS

      Description

      The ancestors table is created by nx_init_ancestors from the existing hierarchy table when switching to path optimizations (now the default).

      This procedure is slow for big hierarchy tables and can be optimized on PostgreSQL and Oracle using recursive queries.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: