Uploaded image for project: 'Moodle app'
  1. Moodle app
  2. MOBILE-4045 Moodle App performance improvements for 4.1.0
  3. MOBILE-4087

DB queries performance summary helper method

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Minor Minor
    • 4.1.0
    • 4.0.2
    • Performance
    • Hide

      Enable DB logging via console: window.browser.setDevelopmentSetting("DBLoggingEnabled", true)

      Reload the app

      This can be tested using the console, some examples:

      dbProvider.printTablesSummary();

      dbProvider.printTablesSummary({dbName: 'MoodleMobile'});

      dbProvider.printTablesSummary({dbName: /Site-/, tableName: 'wscache_2'});{}

      dbProvider.printTablesSummary({tableName: /filepool/});{}

      For clear the logs: dbProvider.clearLogs()

      Show
      Enable DB logging via console: window.browser.setDevelopmentSetting("DBLoggingEnabled", true) Reload the app This can be tested using the console, some examples: dbProvider.printTablesSummary(); dbProvider.printTablesSummary({dbName: 'MoodleMobile'}); dbProvider.printTablesSummary({dbName: /Site-/, tableName: 'wscache_2'}); { } dbProvider.printTablesSummary({tableName: /filepool/}); { } For clear the logs: dbProvider.clearLogs()
    • MOODLE_400_STABLE
    • MOODLE_401_STABLE
    • Moodle App 4.1.0

      This is related to MOBILE-4086

      It would be perfect to have a method to export all the DB queries performance information ready to be imported into a spreadsheet, for example:

      Site-abcde, wscache_mod, INSERT, 325, 1234.34ms
      Site-abcde, wscache_mod, SELECT, 100, 2475,98ms
      any_db, any_table, SELECT|INSER|UPDATE|DELETE, #queries, total_timems

      This will help us to measure if we really improved performance by splitting the wscache table

      This functionality should use the contents within the existing dbProvider.queryLogs array so we can easily reset (empty) that table via the console for doing different tests, the previous might require refactoring the way the information is stored in the queryLogs array

            dpalou Dani Palou
            jleyva Juan Leyva
            Noel De Martin Noel De Martin
            Juan Leyva Juan Leyva
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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