-
Improvement
-
Resolution: Inactive
-
Minor
-
None
-
2.5
-
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.
- has been marked as being related by
-
MDL-30643 Daily Statistics queries are too slow
-
- Closed
-