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

Slow query during VerifyCalendar process in 6.2

    Details

      Description

      Reproduction steps:
      1) Have 100000 entries in CalEvent and AssetEntry tables in 6.2. (You can find a script that adds these entries and the database as well attached)
      2a) Run VerifyCalendar
      or
      2b) Run the following query:
      select * from CalEvent left join AssetEntry on (classPK=eventId) where classPK is null;
      It's from "portal-impl/src/custom-sql/calendar.xml" file

      Actual result: The query is so slow and the VerifyProcess takes a lot of time

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              joyce.wang Joyce Wang
              Reporter:
              istvan.dezsi Istvan Dezsi
              Participants of an Issue:
              Recent user:
              Enterprise Release HU
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 40 weeks, 3 days ago

                  Packages

                  Version Package
                  6.2.X EE