Hi All,
I converted our app to PB2019 R3 build 2703 this week, and noticed it was freezing up whenever I closed a large report. Looking at task manager, the app was taking a large portion of the CPU cycles while appearing frozen. When the CPU usage subsided, the app became responsive again. This was all happening after the report window had closed.
I ran a simple test with the PB sample database and three different sized datawindows: small (100 rows), medium (1,100 rows), and large (8,200 rows), and saw the same behaviour.
When I close the small datawindow, the CPU increases for 2 seconds and then goes back to zero.
When I close the medium datawindow, the CPU increases for 7 seconds and then goes back to zero.
Closing the large datawindow causes the CPU to increase for 95 seconds, during which the application is frozen.
I've tried this with a sql server database, both with the native SNC driver and the new MSOLEDBSQL driver, and then with the 'PB Demo DB V2019R3' sample database, and seen the same lag each time. It occurs both in the IDE and when the app is deployed.
Has anyone else experienced this? If so, how did you fix it?
Thanks in advance,
Monica.
p.s. I've attached the test project I put together.
If your large DWO is housed within in a DC .. then I would also suggest adding this line first in the new destructor code ...
=> THIS.SetReDraw ( FALSE)
If your large DWO's are housed within a DataStore, I would create a custom PB.ini and deploy it with your App EXE, as follows:
[DataStore Behavior]
; No = do NOT use MS-Window handles in DS processing (Default is yes). "No" gives much better performance!
UseHwnd=no
HTH further. Regards ... Chris