Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE XML tools performance comparison

ArekMar 10 2003 — edited Apr 23 2003

Hi,
Does anyone know if there is some kind of summary on various Oracle XML tools (regarding performance)?
I'm about to import into DB 9.2.0.2 large amounts of data from XML files. I do not want to store XML data as XMLType or CLOB, but to get data from XML and store it in relational tables.
What choice do I have and what's the performance of Oracle XML tools?
Let's say - is native XML DB XMLType-and-Extract(...) function solution fast enough to parse 10MB (ca. 50000 "records") XML document in 10 min. time? What is the comparative performance of Oracle XML parsers in XDKs (PL/SQL XDK, Java XDK (DOM vs. SAX), C XDK, etc...). What are other tools that would be appriopriate?
What are the experiences/technologies other developers use to deal with similar problem?
I do appreciate any suggestions.
Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2003

Added on Mar 10 2003

#performance-availability, #xml-db

10 comments

658 views