1. Giuseppe moglia
  2. PowerBuilder
  3. Tuesday, 29 March 2022 08:01 AM UTC

Hi Guys

anyone of you experienced low performances on dw.scrolltorow(row) ?

I've set the setredraw to false before and true after but no way, it takes more than 5 sec....

 

Any hints? 

Jeff Hersey Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 18:49 PM UTC
  2. PowerBuilder
  3. # 1

Hey-

We have similar issues with rendering performance in RDP sessions, and have traced it to the following:

When launching our PB 19 application over RDP,

- if the RDP session loads / maps the user's local workstations printers before our application opened ... our PB app will use the user's local workstation default printer when rendering (drawing) all datawindows ... this makes our application is very slow (glitchy, as it takes 2 to 3 seconds to just switch rows)

- if the RDP session has not finished loading / mapping the user's local workstations printers before our application opens, PB will user a server side printer as the default printer when rendering (drawing) all datawindows ... our application functions as expected. 

This could be related to your issue.  Our TechOps team is trying to engineer a work-around to ensure our PB application is launched with a service side default printer.

Jeff/

Comment
There are no comments made yet.
Giuseppe moglia Accepted Answer Pending Moderation
  1. Wednesday, 30 March 2022 14:36 PM UTC
  2. PowerBuilder
  3. # 2

Thank you

another difference between the machines

the performant one is windows server 2016, the non performant one is windows 10

 

Thanks a lot!

Comment
There are no comments made yet.
Giuseppe moglia Accepted Answer Pending Moderation
  1. Wednesday, 30 March 2022 12:45 PM UTC
  2. PowerBuilder
  3. # 3

Hi guys thanks for your hints but I discovered (may be) where is the point

I did a small app doing a

Retrieve

InsertRow

ScrollToRow 

On customer environement (connected with RDP) it takes more or less 4 sec

On our development enviromenet (connected with RDP) it runs immediately 

Data are more or less the same, ODBC is the same

Maybe it's a configuration of RDP?

I tried disabling clipboard and printer sharing but no way...

 

Thanks a lot 

Comment
  1. Brad Mettee
  2. Wednesday, 30 March 2022 13:59 PM UTC
What printer is default in the RDP environment? If one is not assigned, or there's one with a driver issue, it can make a difference.
  1. Helpful
There are no comments made yet.
Giuseppe moglia Accepted Answer Pending Moderation
  1. Tuesday, 29 March 2022 16:00 PM UTC
  2. PowerBuilder
  3. # 4

I did some other tracing

the scrolltorow is slow after the insertRow..., even if i set setredraw(false) before and "true" after

Any hints?

 

Thanks a lot

Comment
There are no comments made yet.
Marc Wietscher Accepted Answer Pending Moderation
  1. Tuesday, 29 March 2022 10:49 AM UTC
  2. PowerBuilder
  3. # 5

Hi Giuseppe,

what might slow down DataWindow performance are icons (picture control and bitmap() function) and global function calls.

If your DataWindow shares data with any other DataWindow and/or DataStore, you should check these also.

 

Best regards,

Marc

 

 

 

Comment
  1. Brad Mettee
  2. Tuesday, 29 March 2022 14:13 PM UTC
High count of computed columns, or expressions on properties (visible, font, color, etc.) can cause slowdowns too
  1. Helpful
  1. Olan Knight
  2. Tuesday, 29 March 2022 22:20 PM UTC
And, of course, a large number of rows might contribute to the slowdown.
  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.