MySQL Forums
Forum List  »  Connector/Node.js

ExtractValue Performance
Posted by: Alex Vilner
Date: August 25, 2010 03:40PM

I have a 2Mb XML file, which contains a flat and fairly well-defined structure:
<root>
<mnemonic>
<mnemonic_name>
<type>
<short_name>
<min_value>
<max_value>
...
</mnemonic>
</root>

Mnemonic section is repeated about 3500 times. There are about 20 attributes for the mnemonic in total.

I am trying to parse out this XML, using ExtractValue - in a loop that is all too familiar:
1. Get the count of mnemonic nodes
2. Loop
insert into sometable ( col1, col2, ....)
select
extractValue(xml, 'root/mnemonic[$row]/col1),
extractValue(xml, 'root/mnemonic[$row]/col2),
...
<where col1, col2, etc. refer to the actual attributes (mnemonic_name, short_name, etc...)


The speed at which it is going is.... about a record per second.
Given the fact that this is the process that takes about 10 seconds in Oracle (on the same machine), what can be done to speed it up???

Thank you in advance!

--Alex

Options: ReplyQuote


Subject
Written By
Posted
ExtractValue Performance
August 25, 2010 03:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.