Re: XML and Postgres - Mailing list pgsql-novice

From brew@theMode.com
Subject Re: XML and Postgres
Date
Msg-id Pine.BSF.4.58.0503171105570.98143@themode.com
Whole thread Raw
In response to Re: XML and Postgres  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Sean....

> > I had to write a parsing routine that churns through the XML file and
> > loads the data for one record, then dumps it into the database before
> > going back for the next record - it's much more memory efficient, albeit
> > slow - no grouped transactions, but that's all right - it runs in the
> > middle of the night.
>
> In these cases, you can use XML::Twig to break up the file into smaller
> parts--it is quite easy and VERY fast.

Thanks, it was a couple of years ago that I wrote my parsing code, so I'm
not going to change it at this time, but I'll keep that in mind for
the future.

I experimented with Twig (but don't remember the exact results - it was a
year and a half ago), but somehow I missed that you could break the data
up in smaller chunks.  That's really ironic because now I see that the
name Twig is because it's a branch off the tree!!!

Darn.

Thanks.... brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================


pgsql-novice by date:

Previous
From: Si Chen
Date:
Subject: what is and who owns postgresql type of questions
Next
From: brew@theMode.com
Date:
Subject: Re: XML and Postgres