mlong has asked for the wisdom of the Perl Monks concerning the following question:

I am trying to determine what modules are available that might help me to load a large (20MB) XML file into a database based on an XML schema that maps XML fields to database table columns. It also need to do this quickly. Any suggestions?

Thanks.

-Matt

Replies are listed 'Best First'.
Re: Load Large XML File to DB Fast
by marto (Cardinal) on Feb 09, 2006 at 16:53 UTC
    mlong

    The module XML::Twig (Examples and tutorials here) can deal with very large XML files.
    I guess you could use it to quickly read the data from the XML file and insert it into the relevant database fields.

    Hope this helps.

    Martin