| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
