Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Using SQL Anywhere in a multi-threaded PB app

  1. Advice
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Friday, 5 May 2023 20: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?

Pasting a field in a ritchtextedit control
Building faster using ORCA SCRIPT
Responses (1)
mike S
mike S Accepted Answer Pending Moderation
  1. Sunday, 7 May 2023 15:01 PM UTC
  2. PowerBuilder
  3. # 1

true/false on autocommit should not really change anything - really depends on the commit/rollback processing.  if they have bad coding (forgot to commit/rollback) then this would 'fix' the problem by committing transactions that failed.

 

the locking default/settings probably have a lot to do with it, as well as what all is being updated.  read commit is generally standard, but they may have serializable on which will cause a lot of blocking.  defaults are different based on the database driver.

 

they should watch the transactions to see what is causing blocking.  it may be their entire database update strategy is bad.

 

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.