Re: Theoretical Basis for SELECT FOR UPDATE
From: vc <boston103_at_hotmail.com>
Date: 30 Sep 2005 20:01:46 -0700
Message-ID: <1128133443.427135.326210_at_g47g2000cwa.googlegroups.com>
Date: 30 Sep 2005 20:01:46 -0700
Message-ID: <1128133443.427135.326210_at_g47g2000cwa.googlegroups.com>
vc wrote:
> David Cressey wrote:
> [...]
> > By SELECT FOR UPDATE, you take out the higher level lock earlier. This
> > reduces concurrency, but also reduces deadlocks.
> >
>
> SELECT FOR UPDATE is not useful for locking databases and is not
> implemented there.
I do not like the wording. It should be:
SELECT FOR UPDATE is not needed for databases with a locking concurrency scheduler (SQL Sever, etc) and consequently not implemented there.
vc Received on Sat Oct 01 2005 - 05:01:46 CEST