MQSeries.net :: View topic

Jakob_CPH · Posted: Wed Apr 27, 2005 3:26 am Post subject:

Hi,

We have experienced it is expensive to create XML for a WBI SAP adaptor (original made by crossworld). We have A WBI message broker vers 5 csd 4 installed on Z/OS.
The XML that should be created for the adaptor has a big volume. When we create messages with SAPXML from scratch (that is from hard corded ESQL values with loops) the cpu spend is listed in the table below

100 kb use 0.625 3084Q CPU seconds
250 kb use 1.4 3084Q CPU seconds
500 kb use 2,7 3084Q CPU seconds

We estimate the average size will be 250 kb. This means we will not be able to transform from a legacy XML format to SAP XML using less than 1.4 3084Q CPU seconds per message. That sound as a big cpu spending to us.

Have any of you experience of how expensive it is to make XML message of size of approx 250 kb?

Thanks

Jakob Hansen

The code we will use is something like this where we use references instead of SET:

DECLARE TAGnr integer Environment.TAGBCount + 1;

SET OutputRoot.MRM.Data_record.sap_zgeo01_cwdata.sap_zgeo01_z2geostate000.sap_zgeo01_z2geostate000[TAGnr].verb = 'Create';

DECLARE state REFERENCE TO
OutputRoot.MRM.Data_record.sap_zgeo01_cwdata.sap_zgeo01_z2geostate000.sap_zgeo01_z2geostate000[TAGnr] ;

CREATE LASTCHILD OF state NAME 'GEO_TAG' VALUE 'TAGB';
CREATE LASTCHILD OF state NAME 'TXN_TYPE' VALUE TXN_TYPE;
CREATE LASTCHILD OF state NAME 'GEO_STATE_ID' VALUE GEO_STATE_ID;
CREATE LASTCHILD OF state NAME 'GEO_STATE_CODE' VALUE GEO_STATE_CODE;
CREATE LASTCHILD OF state NAME 'GEO_COUNTRY_ID' VALUE GEO_COUNTRY_ID;
CREATE LASTCHILD OF state NAME 'STATUS' VALUE STATUS;
CREATE LASTCHILD OF state NAME 'GEO_LOC_TYPE' VALUE GEO_LOC_TYPE;[list=][/list][list=][/list]