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

Improve speed of workflow model listing

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0-HF17, 7.4
    • Component/s: Workflow

      Description

      The query used to list all (filtered) route models is (DOC_ROUTING_SEARCH_ALL_ROUTE_MODELS):

      SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState = 'validated' AND dc:title LIKE '%'
      

      This is very inefficient and the LIKE (which is here because the same query is used in other cases to do a prefix search) should be removed.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: