[Babeldoc-devel] SqlWriter stage

[Dejan K. <dej...@ya...>]

--- "Leech, Jonathan" <jl...@vi...> wrote:
> Incidentally, I modified my pipeline configuration
> from this:
> XPathSplitter->XPathExtractor->SqlWriter
> to this:
> XslTransform->SqlWriter
> and it really flies.  So I used to split up the XML,
> extract values from it,
> then write each row to the database.  Now I just
> transform the XML into a
> bunch of SQL statements and run them.  Its much
> faster and it might be a
> good pattern in general.
> 
> -Jonathan

I did the same thing in pipeline configuration for one
of projects I have been working on. In fact I wrote
SqlWriter stage for that purpose. Since I had to
manage few other problems I have introduced few
properties that might be confusing at first. For
example, you can define messages that should be
returned in case of error instead of returning
database error message. I guess you have noticed that
you can control wether transaciton should be rolled
back on first error or after all statements are
executed. This was important for my project. You can
also use batch statements altough I haven't noticed
some improvements in my project when using batch
statements with different batch sizes (I am using
Oracle database).

If you have some other ideas how to improve or
simplify this class I would be glad to hear. 

Dejan



__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com