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

Add "time spent waiting for the database" value to the performance info

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.7
    • 2.7
    • Performance
    • MOODLE_27_STABLE
    • MOODLE_27_STABLE
    • MDL-43758_master
    • Hide
      1. Ensure perfdebug admin setting is disabled
      2. Ensure MDL_PERF* vars are not defined in your config.php
      3. Go to your CFG->wwwroot
      4. You SHOULD NOT see the performance info shown in the footer
      5. Set MDL_PERF vars in config.php (http://docs.moodle.org/23/en/Debugging#Performance_info)
      6. Go to your CFG->wwwroot
      7. You SHOULD see the performance info shown in the footer
      8. You SHOULD see a new var named DB queries time with a value in seconds
      Show
      Ensure perfdebug admin setting is disabled Ensure MDL_PERF* vars are not defined in your config.php Go to your CFG->wwwroot You SHOULD NOT see the performance info shown in the footer Set MDL_PERF vars in config.php ( http://docs.moodle.org/23/en/Debugging#Performance_info ) Go to your CFG->wwwroot You SHOULD see the performance info shown in the footer You SHOULD see a new var named DB queries time with a value in seconds

      With MDL_PERF constants enabled we display data like the number of db reads, db writes... There is already a moodle_database::print_debug_time() method, we can refactor the code a bit and add a new performance var with the time spent to finish the query (between query_start() and query_end())

            dmonllao David Monllaó
            dmonllao David Monllaó
            Dan Poltawski Dan Poltawski
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Damyon Wiese Damyon Wiese
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

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