From the Moodle docs, the data abstraction layer (XMLDB) was implemented in version 1.7. Is there a new data abstraction layer beginning 2.X that further improves performance?
Thanks, Tim.
Is it fair to assume then that the stack represented in the XMLDB docs on this page http://docs.moodle.org/dev/XMLDB_introduction is still accurate?
Ah, that is why I was getting confused. So AdoDB has been removed and so has dmllib.php? Does that mean ddllib.php is still active?
In the /lib/dml folder I am seeing all the drivers. We use Oracle, does that mean that:
oci_native_moodle_database.php , oci_native_moodle_package.sql, oci_native_moodle_recordset.php, oci_native_moodle_temptables.php
are all created by the Moodle team?
I imagine that going from 1.9 to 2.0 would bring a nice peformance increase since ADOdb is finally gone.
Is this correct?
That is all basically correct.
Those drivers were written by the Moodle team. More specifically, most of the work was done by Eloy Lafuente.
It should be a nice performance increase. Sadly Oracle's version of SQL is quite a long way from ANSI's, so the driver has do to quite a lot of working-around problems, which does damage perforamnce a bit.
If you look, ddllib.php, dmllib.php etc. still exist bug are very small. They mainly just include all the other files that are needed, and provide an entry-point.
If you were to remake that stack graphic from the doc page would you do it this way...
------------Moodle 2.X------------
Moodle XMLDB || Moodle SQL
---------------------------------
Moodle Database Drivers
---------------------------------
MySQL | PostgreSQL | Oracle | SQL*Server
---------------------------------