Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2
    • Fix Version/s: 2.4
    • Component/s: Gradebook
    • Labels:
      None

      Description

      Putting as 2.3, but might get moved to 2.4 if there isnt time to get it done.

      When fetching user data for gradebook, the entire class data is fetched, then the set is sorted and cut down to the limit sepecfied by the jqgrid. This is not the most efficient way.

      Instead the database can handle the sorting and cutting down of the set, using correct hql querying. And this would end up being MUCH quicker and MUCH less memory hungry than getting the entire set and performing the sorting on them.

        Activity

        Hide
        ernieg Ernie Ghiglione added a comment -
        This has been fixed by Andrey when he improved this for Excel export
        Show
        ernieg Ernie Ghiglione added a comment - This has been fixed by Andrey when he improved this for Excel export
        Hide
        lfoxton Luke Foxton added a comment -
        Moving to 2.4 as we wont be able to get this stable in time for 2.3
        Show
        lfoxton Luke Foxton added a comment - Moving to 2.4 as we wont be able to get this stable in time for 2.3
        Hide
        lfoxton Luke Foxton added a comment -
        Theoretically, this should be possible, using a hql script that translates to:

        select gles.*, usr.* from lams_gradebook_user_lesson gles right join lams_user usr on gles.user_id = usr.user_id, lams_lesson les, lams_grouping grp, lams_user_group usrgrp, lams_group g where les.lesson_id=19 and les.class_grouping_id=grp.grouping_id and g.grouping_id=grp.grouping_id and g.group_id=usrgrp.group_id and usrgrp.user_id=usr.user_id order by usr.first_name asc limit 0,10;
        Show
        lfoxton Luke Foxton added a comment - Theoretically, this should be possible, using a hql script that translates to: select gles.*, usr.* from lams_gradebook_user_lesson gles right join lams_user usr on gles.user_id = usr.user_id, lams_lesson les, lams_grouping grp, lams_user_group usrgrp, lams_group g where les.lesson_id=19 and les.class_grouping_id=grp.grouping_id and g.grouping_id=grp.grouping_id and g.group_id=usrgrp.group_id and usrgrp.user_id=usr.user_id order by usr.first_name asc limit 0,10;

          People

          • Assignee:
            ernieg Ernie Ghiglione
            Reporter:
            lfoxton Luke Foxton
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development