Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Power Builder and WEB API

  1. Advice
0
Votes
Undo
  1. Amit De Picciotto
    Amit De Picciotto
  2. PowerBuilder
  3. Sunday, 12 February 2023 10:07 AM UTC

Dear all,

Currently I'm having traditional PB Windows desktop application that get requests from WEB API via HTTP requests.

The WEB API application already exists

 

Customers facing performance issues when few calling the PB application at once.

 

What is the best approach to overcome it?

Should I try to convert the PB application to multi thread?

 Many thanks!

Slow report rendering
Global Functions Using a DataStore and NVO's, Used...
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 12 February 2023 15:22 PM UTC
  2. PowerBuilder
  3. # 1

Hi Amit;

  It's pretty hard to advise you on this issue as you have not really given us much information to go on. Can you tell us...

  • PB version & build being used?
  • Client O/S version & build?
  • What platform is the Web APi running on?
  • What software is the Web API written in? 
  • Is the Web API on a local or public network? 

Etc 

Regards ... Chris 

 

 

 

Comment
There are no comments made yet.
Amit De Picciotto
Amit De Picciotto Accepted Answer Pending Moderation
  1. Sunday, 12 February 2023 20:16 PM UTC
  2. PowerBuilder
  3. # 2

Sure, yep sorry for the lack of info

  • PB version & build being used? [2021 & 2017]
  • Client O/S version & build? [Not sure what it mean, the client send HTTPS requests via postman]
  • What platform is the Web APi running on? [Use the Windows IIS]
  • What software is the Web API written in? [C#]
  • Is the Web API on a local or public network? [Public]

 

Many thanks!

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Sunday, 12 February 2023 20:26 PM UTC
Hi Amit;

Thanks you for that information!

How is the response time when the Web API is called via Postman?

Regards ... Chris
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 14 February 2023 19:12 PM UTC
BTW: PB App would not be using PostMan for the actual Web API call.

Is it use the HTTPClient object class perhaps?
  1. Helpful
mike S
  1. mike S
  2. Wednesday, 15 February 2023 20:23 PM UTC
IIRC, PB 2017 http client sometimes had performance issues based on certain security settings.
  1. Helpful 1
There are no comments made yet.
Amit De Picciotto
Amit De Picciotto Accepted Answer Pending Moderation
  1. Wednesday, 15 February 2023 13:39 PM UTC
  2. PowerBuilder
  3. # 3

Hi, 

The response time, as long as it is single request is ok, the issue is when multiple users sending requests stimulatingly

 The application not use the HTTPClient object, but, the postman, via tcp ip request C++ DLL and the C++ ask the request from the desktop application

 

It seems that move the all legacy application to PB multi thread will take ages... any idea?

 

Many thanks! 

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 15 February 2023 23:28 PM UTC
Hi Amit;

Your most welcome.

FWIW: I would suggest building a small test app that uses the HTTPClient object class & calls one of your worst Web API's performance wise. Then measure your home grown DLL calling the same Web API to first see what +ve or -ve performance you would get before going "all in" into a refactoring effort.

Food for thought! ;-)
  1. Helpful 1
Amit De Picciotto
  1. Amit De Picciotto
  2. Thursday, 16 February 2023 06:35 AM UTC
Many thanks for the help!
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 16 February 2023 12:58 PM UTC
Welcome ... HTH
  1. Helpful
There are no comments made yet.
Amit De Picciotto
Amit De Picciotto Accepted Answer Pending Moderation
  1. Thursday, 16 February 2023 20:37 PM UTC
  2. PowerBuilder
  3. # 4

Hi Chris, all

Just got another input:

the architecture is like this:

Postman -> .NET application (that get the requests --> C++ DLL that ask from the legacy PB application the required request (as report on PDF format)

 

SO, what is suggesting here here,is:

 

Postman  --> PB application (with the HTTPClient component that listen to requests, did i got it right?

 

WIll it improve performence?

 

What to do with multiple calls? open it as multhi thread, or, open process for every request?

 

 

Thanks

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 16 February 2023 21:04 PM UTC
Hmmm .. that does not sounds like standard Postman behaviour.

You should be calling the Web API's directly from PB without any Postman interaction.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.