[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Re: [xsl] XML to Database Inserts via XSLT
Subject: Re: [xsl] XML to Database Inserts via XSLT From: Stef <stef@xxxxxxxxx> Date: Wed, 9 Mar 2005 16:58:37 -0500 |
Hello Barry, I do not disagree with you, but (sadly ?) the database that is used here is Sybase, and not even an 'upto date' version either (12.0). I am not at liberty to change the underlying database technology sadly, but, them's the breaks. The entity's in question will also have to have a substition performed on one of the elements, and also perhaps a self reference or a reference to another node. Horrible but it should be workable. At least I feel somewhat comforted by the fact that I am not the first to do this, or break this ground. That in itself lends a rather comforting note. regards Stef On Wed, Mar 09, 2005 at 04:21:42PM -0500, Barry Lay wrote: > 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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] XML to Database Inserts v, Barry Lay | Thread | Re: [xsl] XML to Database Inserts v, Barry Lay |
Re: [xsl] XML to Database Inserts v, Brian Chrisman | Date | Re: [xsl] XML to Database Inserts v, Stef |
Month |