Posted: Tue Jun 01, 2004 2:57 pm Post subject: XML transformation XSLT
Master
Joined: 08 Jul 2003 Posts: 205
Hello All,
I have a huge XML structure in the following format.
<shipValue>
<Ship>
........has around 50 elements
</Ship>
<Ship>
........has around 50 elements
</Ship>
// The Ship tag repeats atleast 100 times.
</shipValue>
For such huge structure right now the mapping is done with ESQL......with all the complex logic involved. right now it takes atleast 2 to 3 mts to process such a XML file.
My Question: Would it improve performance ( save time ) to use the XML transformation node ( XSLT ) instead of the ESQL code to map the incoming XML to the outgoing XML.
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
I dont know about XML Transformation node, but you can try using REFERENCE variables to improve performance. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
Parsing large XML structures is a time consuming task - this is not to change. And if you access elements throuhout the entire message it will be more or less fully parsed. I guess that parsing will not be improved by using the XML Transformation.
Its difficult to say if logic performance will be improved if you use XSL stylesheets because it depends on the logic and how many times its repeated.
If I was you I would start looking at the code blocks that are repeatingly executed on <ship> and its child elements. Improving performance here will potentially have great impact.
One thig that I dont like about the XML Transformation node is that the stylesheet file must be located on the disk. I dont think that you can maintain the XSL in the flow. _________________ Kind regards
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum