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

com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryFileNames takes a long time

    Details

    • Story Points:
      1
    • Fix Priority:
      5

      Description

      I have 80099 rows in DLFileEntry, I'm at 13 hours and counting for the upgrade to run on this method alone. I see we are doing a lot of selects against groupId, folderId, fileName but we never add an index against that combination. We just add that column via an alter and get started. At a minimum we should add an index, but a better option would be to somehow not do this upgrade via java but actually run a sql command for it.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 11 weeks, 1 day ago

                Packages

                Version Package
                7.0.0 CE RC1