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

Fulltext search takes more and more time as the number of documents is growing

    XMLWordPrintable

    Details

      Description

      This was rapported by some customers with around 50.000 documents in the DB.
      After investigation, it happens since 5.5 due to changes from NXP-5689
      Seems like the NX_TO_TSVECTOR function is called at each query whereas it should already be done in the index. Altering the FULLTEXT table columns to their previous type solves the problem because the code can handle both cases.

        Attachments

        1. dictionnaire.txt
          655 kB
          Mehidine Kirouani
        2. NuxeoBulkCreation.groovy
          3 kB
          Mehidine Kirouani

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: