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

Extend our DB API to support temporary tables usage to allow for creation of more efficiently performing but not often components

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Inactive
    • Icon: Minor Minor
    • None
    • 2.5
    • Database SQL/XMLDB
    • MOODLE_25_STABLE

      From MDL-30643 arose a discussion with Eloy about some temp table extension for our API (DB), excerpt follows:

      yeah, surely we need some higher level core function doing the:

      • reading from standard xmldb xml file.
      • creation

      problem is I'm not 100% sold to have the definitions in xml file mainly because it's horrible slow to parse the whole lib/db/install.xml just to load one definition.
      slow = 2-3 seconds (for example) Not minutes.

      I mean, can be used for "not-often" operations (backup, cron...)
      also, has the bad effect of creating the real table (the not temp one)
      not critical but not needed at all

      yeah, surely we need to:

      1) list the alternatives
      2) pick one
      3) implement the high-level support for it.

      with alternatives being:

      A) use normal install.xml files (with some flag indicating it's for temp purposes)
      B) use separate temptables.xml files
      C) use in-memory definition. $t = new xmldb_table....

      Nice mini-project for 2.5, feel free
      For 2.4, surely the way is to use standard install.xml. As said it only will add some seconds to the thing. Not much.

            Unassigned Unassigned
            nebgor Aparup Banerjee
            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.