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

Split the wscache_2 table into several wscache tables

    XMLWordPrintable

Details

    • Sub-task
    • Status: Development in progress
    • Major
    • Resolution: Unresolved
    • 4.0.1
    • None
    • Caching
    • None
    • MOODLE_400_STABLE
    • Moodle App 4.1.0

    Description

      We've done some SQLite performance analysis and it seems that the size of a table has a significant impact on performance.

      Since the wscache_2 table is one of the most used tables and also, the largest table by the number of records, it seems to be the very best candidate for optimisation.

      We could implement a simple solution such as having four tables:

      • wscache_core: for core_* WebService requests
      • wscache_mod: for mod_* WS requests
      • wscache_blocks: for blocks_* WS requests
      • wscache_tool: for tool_* WS requests
      • wscache_other: For the rest

      Apart from the previous, we need a way to identify that there have been improvements, so maybe we should improve the current DB profiling tools for capturing DB queries and overall performance time during a session and presenting a report. Using the previous, we should be able to compare two executions (with and without the suggested improvements)

      Attachments

        Activity

          People

            dpalou Dani Palou
            jleyva Juan Leyva
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: