Details
-
Type:
Bug
-
Status: Verified
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 11.4
-
Fix Version/s: 11.5 [Tentative], 12.0, 19.0
-
Component/s: Lessons
-
Labels:
-
12 status:Resolved
-
11 status:Resolved
-
Previous Issue Keys:LSNBLDR-877
-
Test Plan:
Description
findItemsInSite has custom SQL (not Hibernate) that performs a join from the lesson_builder_pages pageId (bigint) on lesson_builder_items sakaiId (varchar(250).
An explain is attached showing the terrible MySQL performance.