|
From: Leech, J. <jl...@vi...> - 2003-08-04 14:32:02
|
I didn't notice that you can control transaction rollback - that's a great feature to have. I'll also take a look at the batch capability. I'll let you know if I have any ideas. -Jonathan -----Original Message----- From: Dejan Krsmanovic [mailto:dej...@ya...] Sent: Sunday, August 03, 2003 11:03 AM To: bab...@li... Subject: [Babeldoc-devel] SqlWriter stage --- "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 ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ Babeldoc-devel mailing list Bab...@li... https://lists.sourceforge.net/lists/listinfo/babeldoc-devel |