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

v6_2_0.UpgradeJournal: updateAssetEntryClassTypeId is really slow because we do not use the index

    Details

      Description

      Steps to reproduce it

      1. Startup a 6.0.12 version (I use this version because the script has been created for this version but we can reproduce it in 6.1.x too)
      2. Create a journal structure and a template.
      3. Execute the attached script to create 100000 journalArticles from Groovy console (the script is valid for 6.0.12). Please set the proper values for the variable before executing it:
      4. Upgrade to Liferay 7

      Check the log and take the time for performing this:

      18:30:20,738 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeJournal
      

      After the commits we should safe time.

      Technical notes
      In Liferay 7 the impact of this has been minimized by LPS-62746 but in 6.2 is still really heavy.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 31 weeks, 4 days ago

                  Packages

                  Version Package
                  6.2.X EE