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

Resolved PB 2019 R3 generated .EXE slow compared to PB 12.6

  1. How-to
0
Votes
Undo
  1. Stein Hemma
    Stein Hemma
  2. PowerBuilder
  3. Wednesday, 2 June 2021 10:00 AM UTC

We recently upgraded from PB 12.6 to PB 2019 R3 (yes, we're a bit slow).
Like some others, we too are experiencing a drastic reduction in performance.
Opening some windows takes double the time of what they used to. A specific composite datawindow now takes three times as long to open.

- We have scanned the community for help and tips and made sure we're running with both PBTHEME.dll and PBJSON.dll.
- We have tried connecting MS SQL Server with both SNC/SQLNCLI11 as well as MSOLEDBSQL/MSOLEDBSQL.
- We have tried to generate both Pcode as well as machine code with speed optimization.

All to no avail. Any help or pointers would be most appreciated.

dbo.pbcattbl needed for application deployment
FindWindowW always returns Zero
Responses (2)
Stein Hemma
Stein Hemma Accepted Answer Pending Moderation
  1. Thursday, 3 June 2021 10:01 AM UTC
  2. PowerBuilder
  3. # 1

Thx for the reply. We tried those settings, but they didn't seem to make a huge difference.
I think we have narrowed this down to freeform datawindows with nested datawindow reports.
Might this be due to the rendering of the dw ?

Some numbers :
                            PB 12.6   PB 2019
Setting dataobject  105 ms     630 ms
Retrieving data       170 ms    700 ms

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 3 June 2021 15:41 PM UTC
Hi Stein .. yes, please try that build. Thanks!
  1. Helpful
Stein Hemma
  1. Stein Hemma
  2. Friday, 4 June 2021 09:31 AM UTC
Did upgrade to 2703. More or less the same result as with 2670.

But - did find that RDP also might pose an issue.



Run locally we are down to 140 ms and 300 ms.

Still somewhat slower than PB 12.6, but acceptable.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 4 June 2021 15:40 PM UTC
Hi Stein .. thank you for the feedback on RDP.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 2 June 2021 15:30 PM UTC
  2. PowerBuilder
  3. # 2

Hi Stein;

  Please try the following ...

1) Using Notepad, please create your own PB.INI file in the App's EXE folder.

2) Add the following entries ...


[Data Window]

; Can improve the speed for large row retrievals ...
; 0: Disable both MSAA and Microsoft UI Automation - 1: Enable both - 2: Enable Microsoft UI Automation only - 3: Enable MSAA only
Accessibility=0

[DataStore Behavior]

; No = do NOT use MS-Window handles in DS processing (Default is yes). "No" gives much better performance!
UseHwnd=no

 

3) Deploy the custom PB.INI with your App EXE's in the same deployment root folder.

HTH

Regards ... Chris

Comment
Roland Smith
  1. Roland Smith
  2. Wednesday, 2 June 2021 18:39 PM UTC
Is there a topic in the help that lists all the runtime settings that can be used?

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 2 June 2021 18:49 PM UTC
Hi Roland ... unfortunately, no. :-(
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.