Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-56835

course participation report very slow just loading filter

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      Legacy log only.
      1. Create a site.
      2. Visit Site administration > Plugins > Logging > Manage log stores
      3. Disable the 'Standard log'.
      4. Enable the 'Legacy log'.
      5. Click on 'Settings' next to 'Legacy log'
      6. Check 'Log legacy data'.
      7. Click 'Save changes'.
      8. Create a course.
      9. Add an assignment to this course.
      10. Enrol a student.
      11. Log in as the student.
      12. Submit something for the assignment.
      13. For the database run the SQL 'UPDATE mdl_course SET timecreated = 1543622400'.
      14. Log in as the admin.
      15. Visit the course.
      16. Click on the cog in the top-right and select 'More...'.
      17. Visit 'Reports' > 'Course Participation'
      18. Confirm 'Look back' goes back 6 months.
      19. In 'Activity module' select the assignment you created.
      20. Press submit.
      21. Confirm the user is listed.
      Standard log.
      1. Create a site.
      2. Create a course.
      3. Add an assignment to this course.
      4. Enrol a student.
      5. Log in as the student.
      6. Submit something for the assignment.
      7. For the database run the SQL 'UPDATE mdl_course SET timecreated = 1543622400'.
      8. Log in as the admin.
      9. Visit the course.
      10. Click on the cog in the top-right and select 'More...'.
      11. Visit 'Reports' > 'Course Participation'
      12. Confirm 'Look back' goes back 6 months.
      13. In 'Activity module' select the assignment you created.
      14. Press submit.
      15. Confirm the user is listed.
      Legacy and standard log
      1. Create a site.
      2. Visit Site administration > Plugins > Logging > Manage log stores
      3. Enable the 'Legacy log'.
      4. Click on 'Settings' next to 'Legacy log'
      5. Check 'Log legacy data'.
      6. Click 'Save changes'.
      7. Create a course.
      8. Add an assignment to this course.
      9. Enrol a student.
      10. Log in as the student.
      11. Submit something for the assignment.
      12. For the database run the SQL 'UPDATE mdl_course SET timecreated = 1543622400'.
      13. Log in as the admin.
      14. Visit the course.
      15. Click on the cog in the top-right and select 'More...'.
      16. Visit 'Reports' > 'Course Participation'
      17. Confirm 'Look back' goes back 6 months.
      18. In 'Activity module' select the assignment you created.
      19. Press submit.
      20. Confirm the user is listed.
      Show
      Legacy log only. Create a site. Visit Site administration > Plugins > Logging > Manage log stores Disable the 'Standard log'. Enable the 'Legacy log'. Click on 'Settings' next to 'Legacy log' Check 'Log legacy data'. Click 'Save changes'. Create a course. Add an assignment to this course. Enrol a student. Log in as the student. Submit something for the assignment. For the database run the SQL 'UPDATE mdl_course SET timecreated = 1543622400'. Log in as the admin. Visit the course. Click on the cog in the top-right and select 'More...'. Visit 'Reports' > 'Course Participation' Confirm 'Look back' goes back 6 months. In 'Activity module' select the assignment you created. Press submit. Confirm the user is listed. Standard log. Create a site. Create a course. Add an assignment to this course. Enrol a student. Log in as the student. Submit something for the assignment. For the database run the SQL 'UPDATE mdl_course SET timecreated = 1543622400'. Log in as the admin. Visit the course. Click on the cog in the top-right and select 'More...'. Visit 'Reports' > 'Course Participation' Confirm 'Look back' goes back 6 months. In 'Activity module' select the assignment you created. Press submit. Confirm the user is listed. Legacy and standard log Create a site. Visit Site administration > Plugins > Logging > Manage log stores Enable the 'Legacy log'. Click on 'Settings' next to 'Legacy log' Check 'Log legacy data'. Click 'Save changes'. Create a course. Add an assignment to this course. Enrol a student. Log in as the student. Submit something for the assignment. For the database run the SQL 'UPDATE mdl_course SET timecreated = 1543622400'. Log in as the admin. Visit the course. Click on the cog in the top-right and select 'More...'. Visit 'Reports' > 'Course Participation' Confirm 'Look back' goes back 6 months. In 'Activity module' select the assignment you created. Press submit. Confirm the user is listed.
    • Affected Branches:
      MOODLE_31_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE
    • Fixed Branches:
      MOODLE_36_STABLE, MOODLE_37_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-56835_master-coursetimecreated

      Description

      When the table mdl_logstore_standard_log is big (my environment has 52.000.000 records) the "Course participation" report is to slow just loading the filters an user must select to run the report.

      My environment is not registering in legacy records.

        Attachments

          Activity

            People

            Assignee:
            markn Mark Nelson
            Reporter:
            marcoblancas Isaac Marco Blancas
            Peer reviewer:
            Nick Phillips
            Integrator:
            Eloy Lafuente (stronk7)
            Tester:
            Janelle Barcega
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            6 Vote for this issue
            Watchers:
            13 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              9/Sep/19

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 40 minutes
                2h 40m