How to reduce the service reponse time in PowerBuilder?

[Former Member]

How do we increase the response time from the web service while we retrive some data in PowerBuilder?  (Web service is used as the data window or source)

[Former Member]

The reason of the first call slowness is :
Webservice client uses XML SOAP message to communicate with server side.This involves XML Serialize and Deserialize which will create temporary class and compile it to temporary assembly.

Because of the temporary class creating and compiling,the performance is slow.
You can try the the XML Serializer Generator tool: sgen.exe to generate a serialized assembly file for webservice proxy dll .
The XML Serializer Generator creates an XML serialization assembly for types in a specified assembly in order to improve the startup performance of a XmlSerializer when it serializes or deserializes objects of the specified types

Please see MSDN help:
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.NETDEVFX.v20.en/dv_fxtools/html/cc1d1f1c-fb26-4be9-885a-3fe84c81cec6.htm

Example:
sgen.exe wsProxy.dll

After it runs,a assembly named wsProxy.XmlSerializers.dll is created in the same directory of wsProxy.dll.
Then,you can call the webservice through proxy dll "wsProxy.dll" by using PB without creating those temporary files.

[Former Member]

Thank you for your responses.

I apologize for not providing complete information.

Version : PowerBuilder version 11.5.1
Operating System: Windows XP

Ours is a Windows based Frontend application and Web service is used as the data source.
We are experiencing issues while loading a policy in the frontend, when the first Policy is loaded it is taking longer time(10 - 20seconds) to retrieve the data but when subsequent policies are loaded it is taking considerably lesser time(2-3 seconds) to retrieve.

Please advice any solution for this issue.

Thanks in advance 🙂 ,

[Former Member]

Does the longer running call happen the first time for everyone or just the first one of the day?

If three people start your app and load a policy 5 minutes apart, do they all take 10-20 or just the first one?

You haven't said anything about the Web Service. Is it PowerBuilder? What app server does it run in?

[Former Member]

Hi Lavanya,

WEB Services obviously carry big overheads. So, whilst you can probably tune the server parts of the equation to some degree, you probably need consider finding the bottle-necks or pain-points.

Cache Client Data

Just as a suggestion, assuming you have a PB Client getting data from web-services, maybe cache some of the data needed. DropDown Datawindows can hold many, many rows and the client will perform very well.  If you have auto-retrieve set and large data sets are retrieved again and again from a web-service, you end up with an irresponsive system.

HTH

Lars

[Former Member]

Help required ASAP...

Appreciate the quick response.

[Former Member]

Hi Lavanya;

   FWIW: Unless you can be a lot more specific on the nature of your application, environment and the exact performance issue(s) you are encountering - I think that anyone reading this thread will be leery to respond.

  Also, don't forget to give us the version & build of your PB, MS-Windows software and any other related products you are using with your application.

Regards ... Chris