Hello,
we migrated our app from PB11 to PB2022 R2 3356 a few month ago.
Some (not all) of our users are complaining about the new speed of our app.
The more windows are opened, the slower the entire software becomes.
If there is one window open, it takes two seconds to open a special test window.
If there a two windows open, it takes 15 seconds to open the same test window again.
Another problem: If the user clicks on a other app in the task bar windows switches to this app immediately without any loss of time. Trying to get back to the Powerbuilder app takes a longer time. This time depends on the number of opened windows in the app. It seems that nothing is happening and after a while the main window of the app appears. While waitung the cpu goes up. This only happens at a few customer, but than on all pc.
I checked the task manager, GDI, memory, cpu. No abnormalities
Any idea?
Thanks for your advice/help
Marco
MS-Windows version & build that the issue is happening with?
-> Win10 Pro, Version 22H2, Build 19045.4509
-> But happening on Win11 too
Are the App users running on real machines or VM's?
-> real machine
Is the App running native of via Citrix, RDP, etc?
-> app is running local
Is the App compiled to P-Code or M-Code
-> P-Code
Is the App 32 or 64 bit compiled?
-> 32bit
What DBMS version & build is the App interacting with
-> SQL Anywhere 17.0.4.2182
What DB Client settings are being used (ie: all SQLCA settings being used)?
dbms = ODBC
dbparm = connectstring ='DRIVER=SQL Anywhere 17;SERVERNAME=demo3;DBN=FAB;DBF=FAB.DB;UID=xxx;PWD=xxx;COMMLINKS=TCPIP(HOST=LOCALHOST);COMPRESS=YES;DisableMultiRowFetch=NO;IdleTimeout=0;LivenessTimeout=0;Integrated=NO;Debug=NO'
sqlreturndata = 'SQL Anywhere'
We will update the database to version 17.0.11.7672 today.
Also check ...
1) SQL tracing at the PB layer is OFF (no SQLCA.DBMS = "TRACE ODB" setting)
2) SQL tracing at the ODBC layer is OFF
3) Connection Pooling at the ODBC layer is ON.
Regards .. Chris