Hi,
We are experimenting with SQL-access to our database and I started Protop SQL activity to look what is happening.
There I see after a request that the "Rec Lck" shows some value (combination of all Reads on the Tables).
Is that normal?
Does SQL always locks the records that it reads? What kind of lock is that?
Is that the same behavior as I should do the same query from Progress with no-lock?
Can I see that also somewhere in Protop? (So the same value under some "Rec Lck" column in some ProTop Screen)
We are experimenting with SQL-access to our database and I started Protop SQL activity to look what is happening.
There I see after a request that the "Rec Lck" shows some value (combination of all Reads on the Tables).
Is that normal?
Does SQL always locks the records that it reads? What kind of lock is that?
Is that the same behavior as I should do the same query from Progress with no-lock?
Can I see that also somewhere in Protop? (So the same value under some "Rec Lck" column in some ProTop Screen)