Re: Optimistic or Pessimistic Concurrency Control?
From: Tony <tony_at_my.isp.net>
Date: Sat, 09 Sep 2000 19:25:23 GMT
Message-ID: <D8wu5.1288$M37.88812_at_bgtnsc07-news.ops.worldnet.att.net>
Date: Sat, 09 Sep 2000 19:25:23 GMT
Message-ID: <D8wu5.1288$M37.88812_at_bgtnsc07-news.ops.worldnet.att.net>
I thought locking WAS a (read, is THE) pessimistic technique.
Tony
"Joe Trubisz" <trubisz_at_cs.sunysb.edu> wrote in message
news:39b42c04_1_at_dilbert.ic.sunysb.edu...
> Tony (tony_at_my.isp.net) wrote:
> : Which is decidedly 'better' (most often used in current commercial
> : databases) optimistic or pessimistic concurrency control and why?
> : Tony
>
> Neither. Most use two-phase locking. Some offer optimistic, but
> it's rarely used.
>
> Joe Trubisz
> Dept. of Computer Science
> SUNY Stony Brook
> Stony Brook, NY 11794
Received on Sat Sep 09 2000 - 21:25:23 CEST