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

Excessive CM queries from Site Info

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.4.x
    • Fix Version/s: 2.5.0
    • Labels:
      None

      Description

      We are using the CM hibernate implementation.

      We have a course site with 23,000 members (approx). Actually it's a project site but that may not be relevant. It has 6 provider IDs that together bring in the combined membership of 23K.

      Going into Site Setup for this site generates 116,000 CM queries (approx), i.e. 5 per user. This obviously has significant performance implications.

      The queries look like:

      select sectioncmi0_.MEMBER_CONTAINER_ID as MEMBER1_62_, sectioncmi0_.VERSION as VERSION
      62_, sectioncmi0_.LAST_MODIFIED_BY as LAST4_62_, sectioncmi0_.LAST_MODIFIED_DATE as LAST5_62_, sectioncmi0_.CREATED_BY as C
      REATED6_62_, sectioncmi0_.CREATED_DATE as CREATED7_62_, sectioncmi0_.ENTERPRISE_ID as ENTERPRISE8_62_, sectioncmi0_.TITLE a
      s TITLE62_, sectioncmi0_.DESCRIPTION as DESCRIP10_62_, sectioncmi0_.CATEGORY as CATEGORY62_, sectioncmi0_.COURSE_OFFERING a
      s COURSE19_62_, sectioncmi0_.ENROLLMENT_SET as ENROLLMENT20_62_, sectioncmi0_.PARENT_SECTION as PARENT21_62_, sectioncmi0_.
      MAXSIZE as MAXSIZE62_ from CM_MEMBER_CONTAINER_T sectioncmi0_ where sectioncmi0_.CLASS_DISCR='org.sakaiproject.coursemanage
      ment.impl.SectionCmImpl' and sectioncmi0_.ENTERPRISE_ID='EBE_Stud,2007'

      select coursesets0_.CANON_COURSE as CANON1_1_, coursesets0_.COURSE_SET as COURSE2_1_, c
      oursesetc1_.MEMBER_CONTAINER_ID as MEMBER1_62_0_, coursesetc1_.VERSION as VERSION62_0_, coursesetc1_.LAST_MODIFIED_BY as LA
      ST4_62_0_, coursesetc1_.LAST_MODIFIED_DATE as LAST5_62_0_, coursesetc1_.CREATED_BY as CREATED6_62_0_, coursesetc1_.CREATED_
      DATE as CREATED7_62_0_, coursesetc1_.ENTERPRISE_ID as ENTERPRISE8_62_0_, coursesetc1_.TITLE as TITLE62_0_, coursesetc1_.DES
      CRIPTION as DESCRIP10_62_0_, coursesetc1_.CATEGORY as CATEGORY62_0_, coursesetc1_.PARENT_COURSE_SET as PARENT18_62_0_ from
      CM_COURSE_SET_CANON_ASSOC_T coursesets0_ left outer join CM_MEMBER_CONTAINER_T coursesetc1_ on coursesets0_.COURSE_SET=cour
      sesetc1_.MEMBER_CONTAINER_ID where coursesets0_.CANON_COURSE=15175

      select coursesets0_.COURSE_OFFERING as COURSE1_1_, coursesets0_.COURSE_SET as COURSE2_1
      , coursesetc1.MEMBER_CONTAINER_ID as MEMBER1_62_0_, coursesetc1_.VERSION as VERSION62_0_, coursesetc1_.LAST_MODIFIED_BY a
      s LAST4_62_0_, coursesetc1_.LAST_MODIFIED_DATE as LAST5_62_0_, coursesetc1_.CREATED_BY as CREATED6_62_0_, coursesetc1_.CREA
      TED_DATE as CREATED7_62_0_, coursesetc1_.ENTERPRISE_ID as ENTERPRISE8_62_0_, coursesetc1_.TITLE as TITLE62_0_, coursesetc1_
      .DESCRIPTION as DESCRIP10_62_0_, coursesetc1_.CATEGORY as CATEGORY62_0_, coursesetc1_.PARENT_COURSE_SET as PARENT18_62_0_ f
      rom CM_COURSE_SET_OFFERING_ASSOC_T coursesets0_ left outer join CM_MEMBER_CONTAINER_T coursesetc1_ on coursesets0_.COURSE_S
      ET=coursesetc1_.MEMBER_CONTAINER_ID where coursesets0_.COURSE_OFFERING=15176

      select meetings0_.SECTION_ID as SECTION13_1_, meetings0_.MEETING_ID as MEETING1_1_, mee
      tings0_.MEETING_ID as MEETING1_70_0_, meetings0_.LOCATION as LOCATION70_0_, meetings0_.START_TIME as START3_70_0_, meetings
      0_.FINISH_TIME as FINISH4_70_0_, meetings0_.NOTES as NOTES70_0_, meetings0_.MONDAY as MONDAY70_0_, meetings0_.TUESDAY as TU
      ESDAY70_0_, meetings0_.WEDNESDAY as WEDNESDAY70_0_, meetings0_.THURSDAY as THURSDAY70_0_, meetings0_.FRIDAY as FRIDAY70_0_,
      meetings0_.SATURDAY as SATURDAY70_0_, meetings0_.SUNDAY as SUNDAY70_0_, meetings0_.SECTION_ID as SECTION13_70_0_ from CM_M
      EETING_T meetings0_ where meetings0_.SECTION_ID=15177

      select officialin0_.ENROLLMENT_SET_ID as ENROLLMENT1_0_, officialin0_.INSTRUCTOR_ID as
      INSTRUCTOR2_0_ from CM_OFFICIAL_INSTRUCTORS_T officialin0_ where officialin0_.ENROLLMENT_SET_ID=1888

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  smarquard Stephen Marquard
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration