Howdy All,
Recently one of our customers started experiencing repeated slowdowns when opening windows, slowdowns that were not present a few months ago. We investigated and determined that the slowdown was seemingly occurring during datawindow retrieval after the backing sql statement had executed but before control was returned to the user. The backing sql statement was completing in seconds, but the user couldn't interact with the window for up to minutes at a time. We could not replicate this anywhere else but on the customer's site.
Eventually we found the following knowledge base article which mentioned a similar issue: https://www.appeon.com/developers/get-help/knowledgebase/powerbuilder-datawindow-hangs-temporarily-after-retrieve.html. We tried applying the workaround mentioned (setting Accessibility=0 in the PB ini file) and it fixed the problem.
This gets us past the problem with this specific customer, but now we're debating whether to make this change to our pb.ini file going forward so that all customers get this fix. Is this a valid long term solution? Are there any negative side effects that could potentially result from this? Thanks!