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

Samigo has some heavy queries when a user first enters the tool, we need to make sure these queries limit by SITE_ID

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.6.2, 2.7.x, 2.8.0
    • Fix Version/s: 2.9.0
    • Labels:
      None
    • Environment:
      We are currently using 2.6.3, but it appears this needs to be fixed in the latest.
    • Previous Issue Keys:
      SAM-1440

      Description

      We have identified the following Samigo queries when a user first clicks on the tool inside of a site. These queries are not limiting by SITE_ID and thus are pulling all published assessments, this is not scaling at all in our environment where we have thousdands of sites and tens of thousands of published assessments.

      Here are the problem queries that we have identified:

      select publishedf0_.ASSESSMENTID as col_0_0_, publishedf0_.FEEDBACKDELIVERY as col_1_0_, publishedf0_.FEEDBACKAUTHORING as col_2_0_, publishedf0_.EDITCOMPONENTS as col_3_0_, publishedf0_.SHOWQUESTIONTEXT as col_4_0_, publishedf0_.SHOWSTUDENTRESPONSE as col_5_0_, publishedf0_.SHOWCORRECTRESPONSE as col_6_0_, publishedf0_.SHOWSTUDENTSCORE as col_7_0_, publishedf0_.SHOWSTUDENTQUESTIONSCORE as col_8_0_, publishedf0_.SHOWQUESTIONLEVELFEEDBACK as col_9_0_, publishedf0_.SHOWSELECTIONLEVELFEEDBACK as col_10_0_, publishedf0_.SHOWGRADERCOMMENTS as col_11_0_, publishedf0_.SHOWSTATISTICS as col_12_0_ from SAM_PUBLISHEDFEEDBACK_T publishedf0_

      select assessment0_.PUBLISHEDASSESSMENTID as col_0_0_, count(assessment0_.ASSESSMENTGRADINGID) as col_1_0_ from SAM_ASSESSMENTGRADING_T assessment0_ group by assessment0_.PUBLISHEDASSESSMENTID

      select publisheds0_.ASSESSMENTID as col_0_0_ from SAM_PUBLISHEDSECTION_T publisheds0_, SAM_PUBLISHEDSECTIONMETADATA_T publisheds1_ where publisheds0_.SECTIONID=publisheds1_.SECTIONID and publisheds1_.LABEL='AUTHOR_TYPE' and publisheds1_.ENTRY='2' group by publisheds0_.ASSESSMENTID

        Gliffy Diagrams

          Zeplin

            Attachments

            1. exportAssessment.xml
              40 kB
            2. scores-page.png
              scores-page.png
              78 kB
            3. vt-SAM-1440-2.7.patch
              2 kB
            4. vt-SAM-1440-2.8.patch
              1 kB

              Issue Links

                Activity

                  People

                  Assignee:
                  samigoteam SAMIGO TEAM (Inactive)
                  Reporter:
                  jkusnetz Jeremy Kusnetz
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  13 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration