I have implemeted the code as per the link http://www.oracle-base.com/articles/8i/parse-xml-documents-8i.php to convert & Load an XML Document to multiple tables in Oracle database. As the number of nodes increase in the xml file, the processing time of XML file is increasing exponentially.(For Example:- if there are more than 500 Employee-Dept details in an XML file, parsing of XML file is taking about 5 hours ) Could anyone let me know what changes can be done inorder to reduce the parsing time.
Tim (Hall) starts with "First, download and install the latest copy of the XDK for PL/SQL.", so yes, you could try again on the XDK forum. As long as you don't upgrade, we can't really help.
Thinking out of the box, a lot has improved since the "birth" of 8i, so alternatively you could load faster Java solutions (parsers etc of non oracle flavor, that is the very old XDK) into Oracle's JVM kernel and access those via you own PL/SQL wrappers / packages.
Edited by: Marco Gralike on Aug 22, 2012 7:33 PM