PRODUCTS

DOWNLOAD

BUY

LEARN

SUPPORT

COMPANY

Cart

[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: XML to Database Inserts via XSLT Play the video Subject: Re: XML to Database Inserts via XSLT From: Barry Lay <blay@xxxxxxxxxxxxxxxxxxx> Date: Wed, 09 Mar 2005 16:21:42 -0500 Stef wrote: Hello Everyone, Well, the subject says it all really. I have a few jobs that I -could- write perl to transform the xml into inserts, however, I would prefer to use XSLT and learn as I go. Another feather in my cap and all that. Stef, I have done this with an Oracle database. The latter actually has a mechanism for directly updating the database from XML but we found it to be very slow. The process you show will work but if you are inserting a lot of rows then the round trips to the database will be a significant component of the run time. Oracle (and some others) provide mechanisms for inserting a lot of rows in one bulk operation, although they may not be available from an interactive SQL processor - you may need to create a program to do it. The most efficient way to do this is probably to write your data out to a delimited text file and use the database load utility. This can result in order-of-magnitude-level improvements in load speed over separate INSERT statements This approach would require that your data rows have the same data elements and be loaded to the same table; I assumed from your example that this might be the case Barry. Current Thread Re: XSLt in RDBMs engine? (was XML to Database Inserts via XSLT), (continued) Barry Lay - 10 Mar 2005 02:07:45 -0000 Chris_Graham - 10 Mar 2005 05:38:38 -0000 Michael Kay - 9 Mar 2005 22:40:27 -0000 Brian Chrisman - 10 Mar 2005 07:40:46 -0000 Barry Lay - 9 Mar 2005 21:21:58 -0000 <= Stef - 9 Mar 2005 21:57:13 -0000 Barry Lay - 10 Mar 2005 00:51:16 -0000 Aron Bock - 10 Mar 2005 04:12:54 -0000 Stef - 10 Mar 2005 16:46:33 -0000 <- Previous Index Next -> Re: XML to Database Inserts v, Brian Chrisman Thread Re: XML to Database Inserts v, Stef Re: The right way to count fr, David Carlisle Date Re: XML to Database Inserts v, Brian Chrisman Month

PURCHASE STYLUS STUDIO ONLINE TODAY! Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE! Accelerate XML development with our award-winning XML IDE - Download a free trial today! Don't miss another message! Subscribe to this list today. Email First Name Last Name Company Subscribe in XML format RSS 2.0 Atom 0.3

Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.