-
Kim Lombard
- PowerBuilder
- Wednesday, 19 March 2025 02:43 AM UTC
Hello, I'm converting a PB 10 app written years ago to PB 22. the migration went fine. The problem is from PB22 the load time for datawindows is VERY slow. We use SQL Server 19 with Azure connection with OLE DB.
Most of the datawindows have embedded SQL statements, a few with upates. But even the initial list of about 3000 rows to a treeview takes almost a minute to load. When I re-wrote that one datawindow to call s stored proc to load time is about the same as the pb 10 version.
A few of the datawindows previously called stored procedures with the majority using PB Select.
I was able to find and use SQL Extract and have the SQL statements, so that part is easy. It would be very time consuming to re-factor all of them.
This (of course) is a mission critical app. I'm up against a deadline and would appreciate some honest thoughtful suggestions that would help.
One of the tables has over 400 million rows, This wasn't an issue until we started having locking / blocking problems and decided to migrate to PB 22.
the framework is PFC from the last century (smiley). I have another app that I migrated last year that works GREAT on PB 22. the users are over the moon. But it doesn't use embedded SQL or PFC as a foundation class, I was built a few years later with a home grown framework.
But as I said, I hoping for suggestions to give us a stop gap solution and don't have to go back to PB 10 and fix it. UGH!
thank you in Advance
Kim Lombard
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.