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

DB reads/writes increased in login submission after landing MDL-71410

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Deferred
    • Icon: Critical Critical
    • None
    • 3.11
    • Activity completion

      Some performance issues have appeared after landing MDL-71410. For instance: https://ci.moodle.org/job/P.00.00%20-%20Attic%20-%20Performance%20comparison%20moodle.git%20vs%20integration.git%20%28master%29/2314/

      Eloy has shared the following information: 

      If the Moodle site hasn't any course, the result is the expected:
      		 
      with purged caches I get: "DB reads/writes: 30/0" before and after
      		 
       
      		 
      With a couple of courses on the site... now I get, in login page:
      		 
      623a3d9 : DB reads/writes: 27/0
      		 
      00dfc98 : DB reads/writes: 30/0(both executed after admin/cli/purge_caches.php )
      		 
       
      		 
      So, maybe it depends on the number of courses... but for sure the difference is before/ after MDL-71410.
      		 
       
      		 
      And it's in the login page... not logged-in, not sure why that page should be triggering anything course-related.

       

        1. perf.pdf
          109 kB
          Eloy Lafuente (stronk7)

            rezaie9 Shamim Rezaie
            sarjona Sara Arjona (@sarjona)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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
                5h

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