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

VCS: improve proxy-based search performance

    XMLWordPrintable

    Details

      Description

      VCS searches involving proxies need to do a
      LEFT JOIN proxies ON proxies.id = _nxhier.id
      JOIN hierarchy ON (hierarchy.id = _nxhier.id OR hierarchy.id = proxies.targetid)
      and the OR part is very costly.

      Find a way to change this, either by using a UNION ALL of two queries (one one normal docs, the other on proxies), or something else.

        Attachments

          Issue Links

            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 - 3 days, 3 hours
                  3d 3h
                  Remaining:
                  Remaining Estimate - 3 days, 3 hours
                  3d 3h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified