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

Resolved Performance issue on Powerbuilder 2019 R3 2728

  1. Issue
0
Votes
Undo
  1. rohit ranjan
    rohit ranjan
  2. PowerBuilder
  3. Thursday, 26 September 2024 10:09 AM UTC

Hi,

One of our Customer have raised the issue of Slowness on their application. 

The application when run from a VM - works normally there is no performance issue.

Same application when run from a laptop - A general slowness is experienced across all the screens, some of them take 10 to 20 seconds to load which normally loads up in less than a second.

We have tried placing a pb.ini with executables with below content and it does not make any difference. The antivirus and other applications are similar for VM and Laptops.

pb.ini -

[Data Window]
Accessibility=0

[DataStore Behavior]
UseHwnd=No

The Powerbuilder version used is - Powerbuilder 2019 R3 Build 2728

Old Application (Powerbuilder 12 if i remember) when run from laptops does not give any performance issue. Though the application has come up a long way, but some of the screens are unchanged. PB 2019 R3 version application is extremely slow.

Can you suggest us what could be the possible reasons and how we can resolve it.

Thanks,

Rohit

 

 

 

Issue in exeucting the line lpbdom_Doc = lpbdom_B...
Printing on Azure VM is very slow compared to citr...
Responses (3)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 26 September 2024 19:54 PM UTC
  2. PowerBuilder
  3. # 1

As Armeen said, it may be that the VM Server and the Database Server are on the same local network (fast) and the laptops are on a remote connection (slow) over the internet.

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 26 September 2024 19:28 PM UTC
  2. PowerBuilder
  3. # 2

Is the database in same local area network as the PB app?  Or is the database in some remote location and you are connecting over Internet to the database from the PB app?

If the database is not in same local area network, that is why your performance is slow.  The secure and way to get good performance for remote deployment is to use PowerServer and you will need to implement PowerServerLabels to reduce how many roundtrips your app makes to the database.  Seems the way your code is written is very chatty with the database if takes 10-20 seconds.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 26 September 2024 14:15 PM UTC
  2. PowerBuilder
  3. # 3

Hi Rohit;

Can you tell us ...

  • What version & build of MS-Windows is being used on the laptop?
  • What Anti-virus version & build is being used on the laptop?
  • What CPU is found on the laptop?
  • How much RAM is in the laptop?

Regards .. Chris

Comment
Brad Mettee
  1. Brad Mettee
  2. Thursday, 26 September 2024 14:44 PM UTC
Also would be helpful to know

- free memory BEFORE and AFTER running application

- is laptop in performance mode, or battery saving?

- is app being run from a network drive on laptop or installed locally?
  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.