MySQL Forums
Forum List  »  Connector/Node.js

Import/Export Large Complex XMl files(700MB) to MySQL tables
Posted by: S K
Date: October 21, 2008 01:13AM

I have a complex xml file am getting from another application in the range of 500-1000MB. This XML has nested tags(foreign keys) upto 5 levels. The first level is account information, second is account history(opening, closing balance, highest buy etc), third......untill the fifth level.

If i parse with SAX, it means i will be processing ta by tag and is taking upto 18 hours to process a 200MB file, which is alot of time. If i use Microsoft access, it processes such a file in 10 minutes.

I got a package called XML-DBMS but this uses DOM meaning files of this nature would not be supported. Am requesting anyone with previous information or hints to provide me with information. How does access do it in so short a time?

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Import/Export Large Complex XMl files(700MB) to MySQL tables
S K
October 21, 2008 01:13AM


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.