× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.