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

Increased DB reads on forum

XMLWordPrintable

    • MOODLE_311_STABLE
    • MOODLE_311_STABLE
    • MDL-74321-master
    • Hide

      Unit tests cover this.

      Something for the integrator:

      1. Compare the performance run with the patch applied to the last on-demand release (efda17d3b02) and confirm that the DB reads have decreased.
      2. Compare the performance run with the patch applied to the on-demand release before the last one (34ce1463ccc) and confirm that the DB reads have not changed.
      Show
      Unit tests cover this. Something for the integrator: Compare the performance run with the patch applied to the last on-demand release (efda17d3b02) and confirm that the DB reads have decreased. Compare the performance run with the patch applied to the on-demand release before the last one (34ce1463ccc) and confirm that the DB reads have not changed.

      After MDL-74121, we noticed an increase in DB queries in forum activities. 

       See the following performance test results:

      between before - 400 (34ce1463ccc on-de...) and after - 400 (06eded2a8bc Merge...)
      		 
      dbreads: increment - View a forum activity, 16% worse
      		 
       
      		 
      dbreads: increment - View a forum discussion, 142.37% worse
      		 
       
      		 
      dbreads: increment - Fill a form to reply a forum discussion, 74.38% worse
      		 
       
      		 
      dbreads: increment - Send the forum discussion reply, 2.63% worse
      		 
       
      		 
      dbreads: increment - All steps data combined, 21.99% worse
      		 
       
      		 
      dbquerytime: increment - View a forum activity, 12.75% worse
      		 
       
      		 
      dbquerytime: increment - View a forum discussion, 92.01% worse
      		 
       
      		 
      dbquerytime: increment - Fill a form to reply a forum discussion, 68.32% worse
      		 
       
      		 
      dbquerytime: increment - All steps data combined, 17.97% worse
      		 
       
      		 
      timeused: increment - View a forum discussion, 23.85% worse
      		 
       
      		 
      timeused: increment - Fill a form to reply a forum discussion, 21.54% worse

        1. forum_check_throttling coverage.png
          forum_check_throttling coverage.png
          4 kB
        2. perf_comparison_with_march_16.pdf
          432 kB

            jpataleta Jun Pataleta
            jpataleta Jun Pataleta
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Victor Déniz Falcón Victor Déniz Falcón
            CiBoT CiBoT
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.