- Roland Smith
- PowerBuilder
- Friday, 5 May 2023 08:00 PM UTC
I developed the shell of a multi-threaded PB2019 app using SharedObjects and passed it to someone else to add in database processing. The whole app runs in the background with the main thread passing processing requests to a new thread which is closed by the main thread once notified.
They are experiencing some blocking in SQL Anywhere.
They have Autocommit set to false so I suggested setting it to true and using BEGIN TRANSACTION before any updates. I haven't heard back yet.
Does anyone have any thoughts on making this system run smoothly?
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.