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

Resolved PowerBuilder Application Performance issue

  1. Advice
0
Votes
Undo
  1. Narayanamoorthy Thangavel
    Narayanamoorthy Thangavel
  2. PowerBuilder
  3. Thursday, 21 April 2022 08:03 AM UTC

Hi All,

 

We are upgraded our PB version from PB 6.5 to PB2017 version. Application are working fine in all the functionality. But we are facing performance issue while we searching any records in any of the screen it takes more than 4 min. But application launch and screen opening are working fine. But while we are searching some thing it will take more than 4 min time to fetch the result. But in older version it will not be there.

I have optimized and recompiled the dll and all but still lack performance. can any one knows how to solve the problem. Because we launched production but we need to fix it soon.

 

Br,

Moorthy

2D Barcode Issues in Powerbuilder 2017 R3
Paste Cell From Excel into Datawindow Single Line ...
Responses (7)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 27 April 2022 19:14 PM UTC
  2. PowerBuilder
  3. # 1

Hi Moorthy;

   Just a random thought but none the less, a very important consideration (not mentioned yet). Make sure that on all your DW Controls and DataStores that you do not have any code (even a blank line) on any RetrieveRow event (that includes DC/DS ancestors as well). That would definitely slow down your entire PB App's DBMS interactions big time.

Regards ... Chris
Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 27 April 2022 16:53 PM UTC
  2. PowerBuilder
  3. # 2

You're saying that pb 6.5 was a lot faster and that you're now connecting to an oracle 19c database? 

1. Is it likely that your databases for 6.5 and newer version are different ones? Was 6.5 running to the exactly same database or is it now a different database on maybe a different server? Hard to compare in that case

2. To start with, 6.5 would be a bit faster, because it wasn't unicode and things just occupy less memory.

3. You still haven't answered my question "What sqlca values are you using to connect?" Maybe you're not using the correct DBMS.

regards

 

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 27 April 2022 15:32 PM UTC
  2. PowerBuilder
  3. # 3

Hi Moorthy;

  Suggestions ...

  1. Run an SQL Trace and see if it's SS that is causing the problem.
  2. If not #1, then run an Application Profile trace to see where the PowerScript code performance issue is.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Narayanamoorthy Thangavel
Narayanamoorthy Thangavel Accepted Answer Pending Moderation
  1. Wednesday, 27 April 2022 07:07 AM UTC
  2. PowerBuilder
  3. # 4

Hi ,

 

I tried both 2019 and 2021 versions but no improvement on performance.

Comment
There are no comments made yet.
Steen Jakobsen
Steen Jakobsen Accepted Answer Pending Moderation
  1. Friday, 22 April 2022 05:18 AM UTC
  2. PowerBuilder
  3. # 5

I had the same problem and deployed the PB.INI with

 

 

[Data Window]

Accessibility=0

[DataStore Behavior]

UseHwnd=No

 

 

And it made ad world of difference.

Now the app does not randomly crash and works fast. :-)

 

//Steen

Comment
Load more comments
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Saturday, 23 April 2022 07:46 AM UTC
Are you sure that the performance issue is not there with PB 6.5 application? Have you applied all the patches for SQL Server? I faced a similar issue when I didn't apply SP4 for SQL 2000. I'm not sure whether your DB is SQL Server or not.
  1. Helpful
Narayanamoorthy Thangavel
  1. Narayanamoorthy Thangavel
  2. Monday, 25 April 2022 05:02 AM UTC
Hi,



I am sure we are 6.6 does not have any performance issue.



If my understanding is right, then you are filtering some values of database fields from PB Application. Is that right? -- Yes i am giving some details in data window and fetching the data .



We are using Oracle 19c DB .
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Tuesday, 26 April 2022 06:41 AM UTC
From previous threads (from my memory) regarding this issue, someone commented that they changed the oracle driver (not sure whether downgraded or upgraded), seems that solved their issue.
  1. Helpful
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Thursday, 21 April 2022 10:32 AM UTC
  2. PowerBuilder
  3. # 6

Moorthy,

Have you tried compiling and deploying in PB 2019 R3?   Can you test at one place, with PB 2019R3 runtimes, for the performance issue?  

Comment
Narayanamoorthy Thangavel
  1. Narayanamoorthy Thangavel
  2. Thursday, 21 April 2022 10:46 AM UTC
Hi Siva,



Let me try 2019 R3 and update you. Thank you.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 21 April 2022 09:04 AM UTC
  2. PowerBuilder
  3. # 7

Hi,

Which Database are you using and which driver?

What sqlca values are you using to connect?

How long did a search take in pb 6.5?

Do you have a touch screen?

Deploy a PB.ini file to the same folder of where your exe is and set:

[Data Window]

Accessibility=0

[DataStore Behavior]

UseHwnd=No

 

Take note that Appeon's solution of setting Accessibility to 0 will improve performance, but won't allow for support of users who need that setting (like blind people). I hope that some day they really fix it, because for now it's the standard reply you'll get.

regards,

MiguelL

Comment
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.