Re: Avoiding any locks in SQL Servers - read and understand....its magic.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

> My line is simply that the most significant failing is that database
> constraints are not implemented (possibly in any commercial database),
> and all you have done is show that if you don't fake database constraints
> properly then you can get serialization to fail.That makes the
> serialization issue
> secondary to the database constraint issue
>
> To date, every example I have seen of Oracle failing to handle
> serialization properly has required the construction of an incorrect
> data model, so I haven't been able to get excited about the issue.

I can't get all that excited about the issue either, but if I did your argument would not calm me. It seems to be a circular argument. The only way to demonstrate a lack of true serializability is to construct a model that one would not construct if one knew about and understood Oracle's lack of true serializability.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB