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

Fulltext JobId index is required even if fulltext is not indexed in database

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 7.10
    • Fix Version/s: 6.0-HF25, 7.10-HF03, 8.1
    • Component/s: Core VCS

      Description

      When using nuxeo.vcs.fulltext.search.disabled=true the fulltext is stored in the database but not indexed (this is done by Elasticsearch)

      In this case the fulltext.jobid column must have an index or we run into performance pb with slow req like

      SELECT "HIERARCHY"."ID" AS "_C1" FROM "HIERARCHY" LEFT JOIN "FULLTEXT" "_F1" ON       37200 7885196.46 7828593.34  1788325405	       36519	  36537 211.967647
      		"HIERARCHY"."ID" = "_F1"."ID" WHERE (("HIERARCHY"."PRIMARYTYPE" IN (:1 , ... :48 )) AND ("_F1"."JOBID" = :49 ))
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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