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

Resolved Performance Issue in Response window

  1. Issue
0
Votes
Undo
  1. himanshi tayal
    himanshi tayal
  2. PowerBuilder
  3. Tuesday, 23 July 2024 18:31 PM UTC

Hello ,

 

We have migrated to PB 9 to PB 2019 (64 bit) version .

And one of the response window is taking 5 - 10 minute to open mle_text where in PB 9 it is opening at the same moment once you click on the Modify button.

But in PB2019 we are facing issues in every button :

1) Once we open Modify button it stuck there for almost 5 min 

2) Once we click on OK after modify something on mle_text it stuck for 5 min again

3) And on closing the response window it stuck again for 2-3 minute.

It is not happened always but very frequently.

I am attaching code snippet for the same which we are using .

Please help me to resolve this performance issue.

 

Attachments (1)
performance_issue_on_responsewindow.pdf
::clipboard() in MRD webclient
A query about the SQLPreview Event
Responses (6)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 23 July 2024 18:51 PM UTC
  2. PowerBuilder
  3. # 1

The pdf you've attached cannot be opened.

Comment
There are no comments made yet.
himanshi tayal
himanshi tayal Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2024 11:20 AM UTC
  2. PowerBuilder
  3. # 2

I have attcahed PDF again .Please check now

Attachments (1)
performance_issue_on_responsewindow.pdf
Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2024 15:56 PM UTC
  2. PowerBuilder
  3. # 3

Hi Himanshi;

  Did you try turning the "Accessibility" feature off (Accessibility=0) ?

FYI: https://docs.appeon.com/pb2022/application_techniques/Creating.html

https://docs.appeon.com/pb2022/pbug/PBINI_settings.html

HTH

Regards .. Chris

Comment
There are no comments made yet.
himanshi tayal
himanshi tayal Accepted Answer Pending Moderation
  1. Thursday, 25 July 2024 13:08 PM UTC
  2. PowerBuilder
  3. # 4

Yes , I have checked with Accessibility=0 in [Datawindow] inpb.ini but it is not working but something need to be modify in below snippet please let me know.

As this is available in each window ,data window ,mle_text properties.

 

Comment
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Thursday, 25 July 2024 13:53 PM UTC
  2. PowerBuilder
  3. # 5

Hi  Himanshi

I have looked through your code and there is not much in the open event that would cause a delay, can you narrow down what is causing the delay by running under debug to see what is not performing?

Regards

David

Comment
himanshi tayal
  1. himanshi tayal
  2. Thursday, 25 July 2024 14:03 PM UTC
Hello David ,



When i have added Messagebox ,performance has fast and the main issue is not in opening this response window .

Performance come into the picture when i click on Modify , OK and Close button .
  1. Helpful
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Thursday, 25 July 2024 14:12 PM UTC
OK, looking at the clicked code it's hard to quantify the For loop, but assuming that has not changed then the only other variable is the database and the select counts(). Are these performing?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 25 July 2024 15:25 PM UTC
  2. PowerBuilder
  3. # 6

Hi  Himanshi;

  Since PB 9 is only 32 bit. Did you first test your PB App in PB 2022 R3 in 32 bit mode first before testing, compiling, & deploying in 64 bit mode?

In other words, does this problem also occur in your PB App in 32 bit mode?

Regards .. Chris

Comment
himanshi tayal
  1. himanshi tayal
  2. Thursday, 25 July 2024 16:08 PM UTC
Yes this is problem with 64 bit ,its working fine with 32 bit
  1. Helpful
John Fauss
  1. John Fauss
  2. Thursday, 25 July 2024 18:12 PM UTC
1. When you migrated the application from PB 9, did you review/follow the information in the Upgrading PowerBuilder Applications publication:

https://docs.appeon.com/pb2019r3/upgrading_pb_apps/index.html

2. For 64-bit, did you review/follow the information in the Migrating 32-bit Applications to 64-bit publication (Note: This publication was issued after PB 2019, but it contains useful information):

https://docs.appeon.com/pb2022r3/migrating_32bit_applications_to_64bit/index.html

If your application calls any Windows API functions via PB external function declarations, there may need to be refactoring performed for 64-bit. The publication listed above can help.

3. Is your application built upon an object framework, such as the PowerBuilder Foundation Class (PFC) or Standard Tool & Die (STD)? If so, did you upgrade the framework libraries to a 2019 version?
  1. Helpful 1
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.