[Info-vax] RDB Question

[Arne Vajhøj]

On 12/3/2018 11:10 PM, Dave Froble wrote:
> On 12/3/2018 9:50 PM, Kerry Main wrote:
>> Also, Rdb supports row level locking which is a pretty big performance
>> feature that some DB's do not support.
> 
> Why do we need different names for things.  Not that I've ever used Rdb, 
> but, isn't that basically the same as a record lock?

Yes.

> And without that, I'm not sure I'd want to use a RDBMS ....

It works without.

Note that we are not talking  functionality of record locking
vs functionality of no locking.

We are talking performance impact of database locking rows vs
performance impact of database locking pages.

Both support the integrity of the database.

But in some cases the performance is better if the
database can lock individual rows instead of locking
pages (8 KB or whatever chunks).

Arne