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

Additional caching of pg_field_type and pg_field_name postgres field column metadata

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Future Dev
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB

      Description

      Both pg_field_type and pg_field_name are called a ton on every page. They are typically extremely fast but they are still load on the db for something which is static in many situations. pg_num_fields might also be in the same boat.

      The driver here is not really increasing an individual page load but the total sql load.

      I suspect it's not possible to use MUC, and it would just shift load to redis etc, so probably the way is directly into apcu and behind a config.php option.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              brendanheywood Brendan Heywood
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: