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

            Assignee:
            melody.wu Melody Wu
            Reporter:
            brett.swaim Brett Swaim
            Participants of an Issue:
            Recent user:
            Esther Sanz
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.0.0 CE RC1