Re: optimistic/pessimistic locks

From: Dan Guzman <nospamplease_guzmanda_at_mindspring.com>
Date: Tue, 2 Jun 1998 07:15:45 -0500
Message-ID: <6l0qep$is2$1@camel19.mindspring.com>

Pessimistic locking will lock the selected rows (e.g. SELECT .... FOR UPDATE). Since the locked rows can't be changed during the transaction, the application does not need to check the before data values. This makes programming easier, but at the expense of concurrency.

> snip <
>
>I never heard about pessimistic locking. Would be intresting what that
>should be ?
>
>Regards,
> Robo.
>
>
Received on Tue Jun 02 1998 - 07:15:45 CDT