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
- relates
-
LPE-16333 Slow query during VerifyCalendar process
-
- Closed
-