Throughput issues due to the increased number of search write requests after LPS-65978

• Type: Regression Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, 7.0.X EE
• Fix Version/s: 6.2.X EE, 7.0.X EE
• Component/s: Search Infrastructure, Social Networking > Ratings, WCM > API > Asset Framework
• Labels:
  • 62-ee-sp20
  • liferay-digital-enterprise-70-sp4
  • liferay-fixpack-de-18-7010
  • liferay-fixpack-portal-151-6210
• Business Value: 4

Regression in liferay-digital-enterprise-70-sp1, liferay-fixpack-de-1-7010 and liferay-fixpack-portal-111-6210.

Solution Notes

Changes introduced in the fix for LPE-15070 (affecting when fields 'ratings' and 'viewCount' get updated in the search index) have been reverted. In addition, these fields will no longer be indexed in the BaseIndexer class for AssetEntry objects as of the next Liferay version.

Why was this change made?

Keeping the Ratings and View Count options in the search index in sync with the database has a negative impact on normal operations due to the significantly increased number of index Write requests causing throughput issues and, therefore, performance degradation.

In addition, the view count is not always up-to-date in the database. This behavior is controlled by the Buffered Increment mechanism. You can find more information about this in the portal.properties file.