Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38012

Joining the bigint pageId on the string sakaiId can be very bad on MySQL

    XMLWordPrintable

Details

    • Merged
    • Resolved
    • LSNBLDR-877
    • Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

    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.

      Gliffy Diagrams

        Zeplin

          Attachments

            Activity

              People

                ottenhoff Sam Ottenhoff
                ottenhoff Sam Ottenhoff
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Git Integration