RE: XML performance issue

I have an api that generates xml using some java that is triggered from an rpg program and writes to the IFS. It is pretty speedy.
I am not sure though how MQ handles the IFS - if it is possible to send MQ messages using IFS files.

Any just a suggestion, and something possibly worth exploring. Initially I was using the IBM XMLTools API but found it far to unwieldy...

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Åke Olsson
Sent: 14 September 2012 12:46
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


-----------------------------------------------------------------------
The information contained in this email is confidential and may also contain privileged information. Sender does not waive confidentiality or legal privilege. If you are not the intended recipient please notify the sender immediately; you should not retain this message or disclose its content to anyone.
Internet communications are not secure or error free and the sender does not accept any liability for the content of the email. Although emails are routinely screened for viruses, the sender does not accept responsibility for any damage caused. Replies to this email may be monitored.
For more information about the Tullett Prebon group of companies please visit the following web site: www.tullettprebon.com

-----------------------------------------------------------------------