Why do I experience slowness after Liferay 7.4 2023.q4?

Issue

• User experiences a slowness in the Liferay 7.4 Q1+ while they check the below query:

SELECT COUNT (*) AS col_0_0_ FROM PortletPreferences portletpre0_ WHERE (portletpre0_.ownerType = ?) AND (portletpre0_.plid = ?) AND (portletpre0_.portletId = ?) AND portletpre0_.ctCollectionId = 0

Environment

• Liferay DXP 7.4 

Resolution

• The fix for case is LPD-24730. In order for the fix to take effect it is required running the upgrade tool, or starting Liferay with the property "database.indexes.update.on.startup=true" at least once. The property should be removed/disabled and not utilized at each Liferay start-up. 

Additional Information

• Portlet Preferences