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

Improve pathOptimizations on Oracle

    XMLWordPrintable

    Details

    • Tags:
    • Upgrade notes:
      Hide

      When upgrading from 5.6 to 5.7 and using Oralce, you need to drop the ancestors table, see the ticket for more information.

      Show
      When upgrading from 5.6 to 5.7 and using Oralce, you need to drop the ancestors table, see the ticket for more information.

      Description

      The DialectOracle.getInTreeSql with pathOptimizations use an "ancestors" table with a nested table to simulate an array of ancestors for each document.

      The index on the nested table is not used during ancestors search, the execution plan is doing a full scan on the ancestor table.

      This does not scales with large amount of documents (>500k). It impacts the move and permanent delete operations.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.