Posted: Thu Mar 30, 2006 7:18 am Post subject: Propagate first or after Stylesheet node - Performance?
Master
Joined: 19 Feb 2004 Posts: 259 Location: Flagstaff AZ
I have a large incoming XML file that in my current flow uses ESQL entirely to transform to the output format. The incoming XML file is a batch of records that are propagated during this transformation.
I am developing a new version. The new version's output XML has changed dramatically. I have a stylesheet now that will perform most of the transformation. I will still need ESQL to do some of the transformation and setup my route to labels.
Question?
Should I let the stylesheet do the transformation to the large file and then pass it on to my compute node that will complete the work and then propagate the batch records...
OR
Should I setup a compute node to propagate the messages first and then send them through the stylesheet node?
My biggest concern at this point is performance. Will firing off the stylesheet node 100 times ( for each record in the batch) be worse or better than one large execution?
Joined: 02 Jun 2005 Posts: 3316 Location: IBM (retired)
Well, firstly I hope you're planning on a 64 bit machine using Broker V6. Aside from general improvements in performance, there's this:
Quote:
The ability to now cache a compiled XML stylesheet in WebSphere Message Broker
V6 has improved message throughput when compared with WebSphere Business
Integration Message Broker V5 which did not have this capability.
The performance reports show a significant improvement in XML transforms using style sheets over V5 of the broker.
I'm not sure there's a "canned" answer to your design question, other that "try it out and see what works best for you". I suspect it depends on what you mean by "large incoming XML file".
btw..are you loding the entire file into a message, or using the file input nodes, or something else? _________________ -wayne
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