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

6.2 to DXP upgrade: com.liferay.portal.verify.VerifyMessageBoards is very slow

    Details

      Description

      This is the query what selects which MBMessages should be updated:

      			SELECT
      				{MBMessage.*}
      			FROM
      				MBMessage
      			LEFT JOIN
      				AssetEntry ON
      					(AssetEntry.classPK = MBMessage.messageId)
      			WHERE
      				(AssetEntry.classPK IS NULL) AND
      				(MBMessage.categoryId != -1)
      

      This is the query what selects which MBThreads should be updated:

      			SELECT
      				{MBThread.*}
      			FROM
      				MBThread
      			LEFT JOIN
      				AssetEntry ON
      					(AssetEntry.classPK = MBThread.threadId)
      			WHERE
      				(AssetEntry.classPK IS NULL) AND
      				(MBThread.categoryId != -1)
      

      They don't utilize index IX_1E9D371D (classNameId, classPK) on AssetEntry table (there is no index for classPK only) so with a large number of assets they are taking a lot of time to execute.

      With 900k AssetEntries it took more than 18 hours.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                norbert.kocsis Norbert Kocsis
                Reporter:
                norbert.kocsis Norbert Kocsis
                Participants of an Issue:
                Recent user:
                Norbert Kocsis
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 42 weeks, 1 day ago

                  Packages

                  Version Package
                  7.0.X EE
                  Master