1. Cheryl Wilkerson
  2. PowerBuilder
  3. Wednesday, 29 June 2022 14:28 PM UTC

I have migrated our application from PB10 to PB21. In testing we noticed a process that was taking longer in PB21. Using profile tracing, I was able to isolate the problem to a section of code that changes dataobjects for 4 of the sub reports of a nested dataobjec. Here is a sample of the code (that is repeated 4 times):

adw_data.object.signature.dataobject = lds_parms.object.signature_dw[ll_parm_row]

The lds_parms datastore has only 67 rows. I tried using GetItemString for getting the lds_parms dataobject and still slow.
I tried using a modify statement instead of the dot notation for setting dataobject - still slow.
(adw_data.Modify("dw_signature.DataObject = ~"" + ls_dataobject + "~""))
When I looked at the profile trace the PB10 log showed for :
 

For the PB21 trace the log shows:

The code is the same. The dataobjects are the same. Any idea why it would take that long to swap dataobject. The reason it matters is because in PB10 the entire process took about 3-4 seconds and now it is double that because of the increase in time to swap dataobjects. Any ideas?

Using:

Cheryl Wilkerson Accepted Answer Pending Moderation
  1. Wednesday, 29 June 2022 16:10 PM UTC
  2. PowerBuilder
  3. # 1

I am running Windows 10 Enterprise for Virtual Desktops server. I did change the pb.ini that is listed under Initialization Path. The ini file already had a [Data Window] section so I modified as follows (added Accessibility and created new bracketed  section for DataStore Behavior:

[Data Window]
Accessibility=0
GridOn=0
GridShow=0
GridX=8
GridY=8
new_default_datasource=5
new_default_presentation=2
Outline_Objects=1
PreviewOnNew=no
PreviewRetrieve=0
Preview_RetainData=1
PrintOnNew=Yes
PrintPreviewRulers=No
PrintPreviewZoom=100
Ruler=0
Status=0
stored_procedure_build=1
OverlayLineWidth=1

[DataStore Behavior]
UseHwnd=no

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 29 June 2022 16:33 PM UTC
That sounds correct then. As Armeen suggested then before, please open a support ticket for this issue. Thanks!
  1. Helpful
There are no comments made yet.
Cheryl Wilkerson Accepted Answer Pending Moderation
  1. Wednesday, 29 June 2022 15:52 PM UTC
  2. PowerBuilder
  3. # 2

Made the changes to pb.ini and saved. Exited PB and logged off server. Logged back in and tried in IDE but it is still taking same amount of lengthy time.
I created a profile trace  and it showed the same duration as before. The PB.ini change made no difference in performance.

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 29 June 2022 16:01 PM UTC
FYI: Make sure that you changed the PB.ini as listed in the IDE's System Options dialogue to get the correct instance location.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 29 June 2022 14:52 PM UTC
  2. PowerBuilder
  3. # 3

Hi Cheryl;

  I suspect that the issue might be the new Microsoft Accessibility code in the PB runtime. Please try the following ...

1) Open Notepad utility and create a "custom" PB.ini file.

2) Add the following sections and key values ...

[Data Window]
Accessibility=0

[DataStore Behavior]
UseHwnd=no

3) Copy the new custom PB.ini to where your App's EXE resides.

Tip: Add these settings to the PB.INI for your PB IDE to test running the App from the IDE.

HTH

Regards ... Chris

 

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 29 June 2022 15:33 PM UTC
Adding to what Chris said, if this suggestion doesn't resolve your issue, then please open a support ticket. https://www.appeon.com/standardsupport/newbug
  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.