Comparison With MySQL... is Oracle XML DB slower than MySQL?????
573595Jul 19 2007 — edited Jul 20 2007As far as i know, Oracle XMLDB has a main feature to manipulate all the XML data. So, i tested with MySQL to compare which one is faster to translate and store the XML data. As far as i know, MySQL has no features like XMLDB to translate XML files internally. We need some application like PHP, Java etc. to translate the XML files to be readable and insert into MySQL.
Ok, my test was simple. I would like to insert the content from a collection of XML files in a folder into Oracle and MySQL as a relational table. I knew that Oracle XMLDB can translate the XML Files and insert into another Relational table.
Process (1)
From that ability, i created two tables in Oracle, the first one was an XMLType table and the second one was a relational table. I created a PHP file to insert XML files/data into the XMLType table. My idea was to insert a collection of XML data into the XMLType table. Then, i created a trigger to retrieve data from XMLType table into the relational table. The final result was in the relational table i have created. The column in the relational table was cretaed based on the elements in the XML files. It can be simplified like this:
directory of XML files inserted by PHP code-> XMLType Table ----using trigger---> Relational Table.
Process (2)
MySQL has no feature like XMLDB, so i created a relational table based on the XML file elements. What i did was i created a PHP file to translate the XML files and changed to be readable by MySQL. After that i needed to insert into the relational table i have created before in MySQL. It can be simplified like this:
directory of XML files translated and inserted by PHP code-> Relational Table.
I ran both of the PHP files. PHP file to insert into oracle and PHP file to translate and insert into MySQL. I tested with 9967 XML files.
The final result was
The process (1) took 1 hour and 2 minutes BUT the process (2) took only 5 minutes.
So, anyone help me why this phenomena could be happen? What's wrong? Any suggestion to make the XMLDB process faster than MySQL?
=)