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

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

    Details

    • 12 status:
      Resolved
    • 11 status:
      Resolved
    • Previous Issue Keys:
      LSNBLDR-877
    • Test Plan:
      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

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code