cancel
Showing results for 
Search instead for 
Did you mean: 

Update with isolation_level vs. select with lock

08-30-2024 10:42 AM
MCMartin Participant
799 views 2 comments
0 Likes
SAP Managed Tags
Labels
sql anywhere
Subscribe

What is the better approach to synch the update between multiple clients, when each row represents a task:

    update first taskstable set P=... where P='' Option(isolation_level = 2)

or 

    select first ID from taskstable with (UPDLOCK) where P='';
and when doing the update based on ID    update taskstable set P=... where ID = ... 

or any other suggestions?

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

MCMartin
Participant
0 Likes

Thanks for the suggestion, I am waiting for my user account on the Forum