RE: XML performance issue

This may seem kind of random but how are you handling the MQ part? I ask because here we don't have the IBM product but make calls to JAVA code that places entries onto queues for us. The program doing the sending was starting and stopping the JAVA environment for each message.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Åke Olsson
Sent: Friday, September 14, 2012 6:46 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: XML performance issue

We are about to roll out an integration to a remote system where XML is the
decided way to go. We create messages with all the information for one
product and send via MQ.

We have the process in place messages are created, syntactically correct and
sent.

That would seem all right would it not?

Not quite. It is all going pretty slow.

Some metrics:

Each XML message is from 15Kto 30K characters in length. Characters not
bytes - since the messages are in UTF-16 (CCSID-1200) the message length in
bytes is double that.

Generating and sending messages for 64K products took just over 6 and half
hours. This to me seems like a lot.

I have tried using blocked SQL fetch to speed up the reading of all the
involved files - no significant change.
All possible indexes have been applied.

As for the XML message creation this is done by regular string handling,
building the MQ message step by step. I have a hard time finding anything
horribly wrong there either.

Question: Is there any high performance tool out there that could
significantly speed up the generation of XML?


Med vänlig hälsning / Best regards

Åke H Olsson
[Description: cid:image001.png@01CA1FE6.387A03A0]
Box 433 SE 551 16 Jönköping Sweden visit: Brunnsgatan 11
phone: +46 (0)36 342976 mobile: +46 (0)705 482976 fax: +46 (0)36 34 29 29
ake.olsson@xxxxxx<mailto:ake.olsson@xxxxxx> www.pdb.se

Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.