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

          depends on

          New Feature - A new feature of the product, which has yet to be developed. NXP-17396 Allow separate repository DDL generation

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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: