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

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-11388 Failure to find proxies by STARTSWITH on Oracle

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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: