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).