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

Improve JournalArticleLocalization queries

    Details

      Description

      There are many queries in /portal-master/modules/apps/journal/journal-service/src/main/resources/META-INF/custom-sql/default.xml that filter based on JournalArticleLocalization.companyId and JournalArticleLocalization.articlePK, but there is no index that takes into account the companyId.

        Attachments

          Activity

            People

            Assignee:
            brian.chan Brian Chan
            Reporter:
            mariano.alvaro Mariano Álvaro
            Engineering Assignee:
            Mariano Álvaro
            Recent user:
            Tomáš Polešovský
            Participants of an Issue:
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                7.3.1 CE GA2
                7.3.2 CE GA3
                7.3.10 DXP GA1
                Master