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

Samigo slow performance for counting assessments in large sites

    Details

    • 19 status:
      Resolved
    • 12 status:
      Resolved
    • Test Plan:
      Hide

      Create a site with 1000+ users

      Create a bunch of assessments in that site, the more the better! The assessment size matters not.

      Notice that when loading samigo as an instructor where the counts are visible that it takes a while to load.

      Show
      Create a site with 1000+ users Create a bunch of assessments in that site, the more the better! The assessment size matters not. Notice that when loading samigo as an instructor where the counts are visible that it takes a while to load.

      Description

      A slow query found when a site contains a large number of users:

      Query_time: 7.483818 Lock_time: 0.000281 Rows_sent: 72504 Rows_examined: 291796

      select assessment0_.PUBLISHEDASSESSMENTID as col_0_0_, assessment0_.AGENTID as col_1_0_, count(*) as col_2_0_ from SAM_ASSESSMENTGRADING_T assessment0_ cross join SAM_AUTHZDATA_T authorizat1_ where
       assessment0_.FORGRADE=0 and authorizat1_.FUNCTIONID='OWN_PUBLISHED_ASSESSMENT' and authorizat1_.AGENTID='a81c1794-6327-4d53-907b-c78b1f8550f8' and assessment0_.PUBLISHEDASSESSMENTID=authorizat1_.QUALIFIERID and (assessment0_.STATUS=0 or assessment0_.STATUS=6) group by assessment0_.PUBLISHEDASSESSMENTID , assessment0_.AGENTID order by assessment0_.PUBLISHEDASSESSMENTID, assessment0_.AGENTID
      

      Relates to counting submissions for each user for every assessment.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ern Earle R Nietzel
                Reporter:
                ern Earle R Nietzel
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code