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

Make NXQL ecm:path STARTSWITH operator more scalable

    XMLWordPrintable

    Details

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

      Description

      The NXQL startswith operator uses either a descendants table if populated either a stored procedure named NX_IN_TREE.

      The number of rows in the descendants table is around max depth * nb documents, there are 3 indexes on this table.
      This makes the table enormous when having millions of documents.

      The NX_IN_TREE has a constant cost per filtered row (like 1s for 1000 rows) and don't scale with query that return more than thousands docs.

      When having millions of documents the startswith operator can be desactivated by adding a single line in the descendants table.

        Attachments

        There are no Sub-Tasks for this issue.

          Activity

            People

            • Assignee:
              bdelbosc Benoit Delbosc
              Reporter:
              bdelbosc Benoit Delbosc
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3 days
                3d
                Remaining:
                Remaining Estimate - 3 days
                3d
                Logged:
                Time Spent - Not Specified
                Not Specified