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

Improve JournalArticleFinder queries when JournalArticleLocalization is involved

    Details

      Description

      After LPS-73630 we are left joining JournalArticleLocalization just in case someone sorts based on title. This has two drawbacks:

      1. This penalizes when we don't need title field at all.
      2. There's no index on JournalArticleLocalization title or description fields, so it can be a heavy query.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Master