Best way to parse XML file and load it into database?
843834May 7 2009 — edited May 9 2009Hi,
I am working on project where I need to parse the xml file and load it into database.
Other applications will make use of this data. XML file size may vary from 1 MB to 2 GB approximately. All these xmls will conform to one single set of XSD files.
I am planning to carry out POC to determine the best way to perform the above job in best efficient manner in terms of performance, memory usage and CPU utilization.
I know some of the options like STAX, JAXB for Java. If some one can provide ideas on other approaches (even outside java will be fine) and comparisons/benifits in terms of performance, memory and CPU usage.