Submit Feedback
Legacy Knowledge Base
Published Sep. 10, 2025

Performance Issues in Publications after Upgrading to 2024.Q1

Written By

Tímea Bihari

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

  • Users may experience a performance drop when working with Publications.

  • This is especially noticeable when navigating through Web Content within an active publication.

     

Environment

  • Liferay DXP 2024.Q1

 

Resolution

The recommended solution is to request a hotfix from Liferay Support that includes the fixes for LPD-57309 and LPD-33371. This hotfix resolves the performance issue by adding a permanent database index.

As a temporary workaround for testing purposes, the following index can be added manually to the database:

CREATE INDEX IX_JournalArticleLocalization_SlownessIndex ON JournalArticleLocalization (ctCollectionId, companyId, articlePK, languageId)

Disclaimer: This manual index is temporary. It will be removed if the portal is configured to update indexes on startup (e.g., if database.indexes.update.on.startup=true or upgrade.database.auto.run=true are set in the portal-ext.properties file).

 

Did this article resolve your issue ?
Legacy Knowledge Base
Did this article resolve your issue ?