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

Missing Indexes in indexes.sql cause upgrades from 5.x to 6.1.20 to take > 65 days

    Details

      Description

      While working on LPP-4193, it was mentioned that I should log an LPS ticket for the general fix.
      When working with very large databases, several SQL queries were doing a full-table-scan which was causing upgrades from 5.x to 6.1.20 to take > 65 days.

      The fix is to add several table indexes to indexes.sql

      In discussion about this, it was mentioned that this perhaps could be categorized as a bug instead of a new feature/improvement because an SQL query that takes over 65 days to complete does not seem like functioning code.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ginson.ren Ginson Ren
              Reporter:
              james.lefeu James Lefeu (Inactive)
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 6 weeks, 4 days ago

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 weeks, 7 hours
                  2w 7h

                    Packages

                    Version Package
                    6.0.X EE
                    6.1.2 CE GA3
                    6.1.30 EE GA3
                    6.2.0 CE M2