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)
4 Answers
-
Former MemberPosted on Nov 15, 2013 at 01:33 AMThe 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 typesPlease see MSDN help:
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.NETDEVFX.v20.en/dv_fxtools/html/cc1d1f1c-fb26-4be9-885a-3fe84c81cec6.htmExample:
sgen.exe wsProxy.dllAfter 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.Add comment
-
Former MemberPosted on Nov 12, 2013 at 09:33 PM
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
Add comment
-
Former MemberPosted on Nov 13, 2013 at 03:12 PM
Thank you for your responses.
I apologize for not providing complete information.
Version : PowerBuilder version 11.5.1
Operating System: Windows XPOurs 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 :-) ,
Add comment
Add comment