Details

    • Sub-task
    • Status: Testing in progress
    • Minor
    • Resolution: Unresolved
    • 4.0.1
    • None
    • 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 App 4.1.0

    Description

      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

      Attachments

        Activity

          People

            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

            Dates

              Created:
              Updated: