Home » Developer & Programmer » JDeveloper, Java & XML » XMLDOM import performance
XMLDOM import performance [message #133015] Wed, 17 August 2005 05:03
mikejf
Messages: 1
Registered: August 2005
Location: london
Junior Member
Hi

Im importing large amounts of XML into Oracle and wanted to ask some questions about performance. I currently register my schemas in oracle and validate my xmltype data against them
using

vl_xmlcode.createSchemaBasedXML( '<schema name>');

I understand about structured storage of XML versus CLOB based
storage for the XML when inserted into the under lying tables
created by oracle when the schema are registered. I also know
that when taking this approach structured storage is better.

But my question is what happens in performance terms when an
XMLDOM document is created from an XMLTYPE and the data is
accessed directly from the dom node tree ? Does this degrade
performance. (Without storing in tables).

I can see that the alternative is to insert into the structured
tables and use xpath call to search the data.

cheers
Previous Topic: How to get the Error Status in Shell Variable
Next Topic: Help for Java Stored Procedure
Goto Forum:
  


Current Time: Thu Mar 28 15:05:41 CDT 2024