Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-55602

Exclude article content from keyword search to improve performance when using DB

    Details

      Description

      1. Create 2,000 web contents with 20,000+ characters
      2. Go to Control Panel -> Web Content
      3. Search for test
      RESULT: Search will take 30 seconds.

      thread dump shows that JournalArticleFinderImpl.doCountByC_G_C_A_V_T_D_C_T_S_T_D_S_ is the slow method.

      this is because of the volume of the column "content" being searched. If "content" is removed from the query, it returns results in less than 1 second.

      Searching content should be optional through the advanced search and should not be done through the keyword search since those searches should be done through the index and not the DB.

      setting a property to allow content searches would enable the end user to prefer more results or faster queries based on their business needs.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sherry.zhu Sherry Zhu
                Reporter:
                andrew.betts Andrew Betts
                Participants of an Issue:
                Recent user:
                Marta Elicegui
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  5 years, 3 weeks, 2 days ago

                  Packages

                  Version Package
                  6.1.X EE
                  6.2.4 CE GA5
                  6.2.X EE