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

UpgradeMessageBoards#deleteEmptyMBDiscussion queries are inneficient in MySQL

    Details

      Description

      Queries to delete inside UpgradeMessageBoards#deleteEmptyMBDiscussion are not efficient in MySQL, because deletes with subselects doesn't use optimizer (see https://dev.mysql.com/doc/refman/5.6/en/subquery-optimization.html)

      Steps to Reproduce:

      1. In a 6.2.X clean bundle, with MySQL, insert several (for example 100000) journal articles.
      2. Check that equivalent entries are inserted in AssetEntry, MBDiscussion, MBMessage, MBThread .
      3. Execute upgrade to DXP

      Expected Results:
      UpgradeMessageBoards step should not take more than 10 minutes.

      Actual Results:
      UpgradeMessageBoards step is taking more than an hour.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 46 weeks, 5 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP10
                  7.0.0 DXP SP2
                  7.0.3 CE GA4
                  7.1.X
                  Master