Understanding locks

SQL++
1

Hello,

I have read there are three locks and at one lock level you can not modifiy the data until the first operation is done.

So when I have 5 columns

name,stars,rating,variants,date

when I make an transaction and update my rating and I lock this, but in this time another request updates the variants is it possible ? Is the whole row locked or only the key/column ?

I use persistToMajority lock level

2

Transactions are on whole documents.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.