Skip to Content
author's profile photo
Former Member

How to reduce the service reponse time in PowerBuilder?

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)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Nov 15, 2013 at 01:33 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 11, 2013 at 03:51 PM

    Help required ASAP...

    Appreciate the quick response. 😊

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo
    Former Member
    Posted 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
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted 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 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 :-) ,

    Add comment
    10|10000 characters needed characters exceeded

    • 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?