WS problems

2015-06-29
I have some problems with a new Web service that runs too slow compared to an older one of the same kind.
The old service retrieves 1000 records from a table and returns 9 xml tags per record within 2-3 seconds, which is ok. This one has been running perfectly for years now.
A new service that we are testing takes about 15 seconds to retrieve only 100 records with 17 xml tags a record. The extra tags are filled by chaining an extra file but I have tested the routine without those extra "gets" with the same negative response time. I also ran tests with direct CALL from a program just to eliminate the xml conversion. In those cases, it took less than 3 seconds to retrieve 300 records in both services.
I also measured the time by writing timestamps into a file at the start and at end of the call just to eliminate the time for transportation of data and conversion in the GUI. That gave the same results as I found in the GUI display.
Both services are part of a Service program written in RPG and use SQL for retrieving the records. The data is returned using an array with maximum 1000 element but only the actual numbers are converted to xml.
The OS version on i5 is 6.1.
Are there any limitations in iseries that make the new service with more element per record work slower? If so is there a way for me to make any changes in the system. Or is the difference in time to find elsewhere?


Med vänlig hälsning

Janne Lindh
Konsult
Janne.lindh@xxxxxxxx





[Beskrivning: Beskrivning: cid:image002.png@01CD05A9.5F7EA680]
evry.com
_________________________

EVRY One Blue AB
Mobil: +46 (0) 70 342 2466

Besöksadress : Ekenbergsvägen 113
Postadress : 171 79 SOLNA

EVRY är resultatet av fusionen mellan EDB, ErgoGroup och SYSteam. EVRY är ett ledande nordiskt IT-företag som kombinerar verksamhetskunnande och IT-kompetens med lokal närhet och flexibilitet.

This message contains information which may be confidential and privileged. Unless you are the intended recipient (or authorized to receive this message for the intended recipient), you may not use, copy, print, disseminate or disclose to anyone the message, the attachments hereto or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail, and delete the message with any attachments.