Re: XML to Database Inserts via XSLT

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.