Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-36980 Very slow navigation when working with question pools
  3. SAK-37169

Batch fetch on answer feedback to speed up publishing of question pool assessment

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4
    • Fix Version/s: 10.6
    • Labels:
      None

      Description

      More batch-fetching needed. Observed using Yourkit.

      For a 100 question assessment, when publishing, I saw 900 queries to these two queries:

      select answerset0_.ITEMTEXTID as ITEMTEXTID151_3_, answerset0_.ANSWERID as ANSWERID3_, answerset0_.ANSWERID as ANSWERID154_2_, answerset0_.ITEMTEXTID as ITEMTEXTID154_2_, answerset0_.ITEMID as ITEMID154_2_, answerset0_.TEXT as TEXT154_2_, answerset0_.SEQUENCE as SEQUENCE154_2_, answerset0_.LABEL as LABEL154_2_, answerset0_.ISCORRECT as ISCORRECT154_2_, answerset0_.GRADE as GRADE154_2_, answerset0_.SCORE as SCORE154_2_, answerset0_.DISCOUNT as DISCOUNT154_2_, answerset0_.PARTIAL_CREDIT as PARTIAL11_154_2_, itemdata1_.ITEMID as ITEMID150_0_, itemdata1_.SECTIONID as SECTIONID150_0_, itemdata1_.ITEMIDSTRING as ITEMIDST3_150_0_, itemdata1_.SEQUENCE as SEQUENCE150_0_, itemdata1_.DURATION as DURATION150_0_, itemdata1_.TRIESALLOWED as TRIESALL6_150_0_, itemdata1_.INSTRUCTION as INSTRUCT7_150_0_, itemdata1_.DESCRIPTION as DESCRIPT8_150_0_, itemdata1_.TYPEID as TYPEID150_0_, itemdata1_.GRADE as GRADE150_0_, itemdata1_.SCORE as SCORE150_0_, itemdata1_.PARTIAL_CREDIT_FLAG as PARTIAL12_150_0_, itemdata1_.DISCOUNT as DISCOUNT150_0_, itemdata1_.ANSWER_OPTIONS_RICH_COUNT as ANSWER14_150_0_, itemdata1_.ANSWER_OPTIONS_SIMPLE_OR_RICH as ANSWER15_150_0_, itemdata1_.HINT as HINT150_0_, itemdata1_.HASRATIONALE as HASRATI17_150_0_, itemdata1_.STATUS as STATUS150_0_, itemdata1_.CREATEDBY as CREATEDBY150_0_, itemdata1_.CREATEDDATE as CREATED20_150_0_, itemdata1_.LASTMODIFIEDBY as LASTMOD21_150_0_, itemdata1_.LASTMODIFIEDDATE as LASTMOD22_150_0_, sectiondat2_.SECTIONID as SECTIONID147_1_, sectiondat2_.ASSESSMENTID as ASSESSME2_147_1_, sectiondat2_.DURATION as DURATION147_1_, sectiondat2_.SEQUENCE as SEQUENCE147_1_, sectiondat2_.TITLE as TITLE147_1_, sectiondat2_.DESCRIPTION as DESCRIPT6_147_1_, sectiondat2_.TYPEID as TYPEID147_1_, sectiondat2_.STATUS as STATUS147_1_, sectiondat2_.CREATEDBY as CREATEDBY147_1_, sectiondat2_.CREATEDDATE as CREATED10_147_1_, sectiondat2_.LASTMODIFIEDBY as LASTMOD11_147_1_, sectiondat2_.LASTMODIFIEDDATE as LASTMOD12_147_1_ from SAM_ANSWER_T answerset0_ inner join SAM_ITEM_T itemdata1_ on answerset0_.ITEMID=itemdata1_.ITEMID left outer join SAM_SECTION_T sectiondat2_ on itemdata1_.SECTIONID=sectiondat2_.SECTIONID where answerset0_.ITEMTEXTID=? order by answerset0_.SEQUENCE asc 670 0 900

      select itemtextat0_.ITEMTEXTID as ITEMTEXTID151_1_, itemtextat0_.ATTACHMENTID as ATTACHME1_1_, itemtextat0_.ATTACHMENTID as ATTACHME1_156_0_, itemtextat0_.RESOURCEID as RESOURCEID156_0_, itemtextat0_.FILENAME as FILENAME156_0_, itemtextat0_.MIMETYPE as MIMETYPE156_0_, itemtextat0_.FILESIZE as FILESIZE156_0_, itemtextat0_.DESCRIPTION as DESCRIPT7_156_0_, itemtextat0_.LOCATION as LOCATION156_0_, itemtextat0_.ISLINK as ISLINK156_0_, itemtextat0_.STATUS as STATUS156_0_, itemtextat0_.CREATEDBY as CREATEDBY156_0_, itemtextat0_.CREATEDDATE as CREATED12_156_0_, itemtextat0_.LASTMODIFIEDBY as LASTMOD13_156_0_, itemtextat0_.LASTMODIFIEDDATE as LASTMOD14_156_0_, itemtextat0_.ITEMTEXTID as ITEMTEXTID156_0_ from SAM_ATTACHMENT_T itemtextat0_ where itemtextat0_.ITEMTEXTID=? order by itemtextat0_.CREATEDDATE asc 432 0 900

        Gliffy Diagrams

          Zeplin

            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 Integration