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.
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--