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

> > well as the transaction manager itself. With MVCC and MVTO it is
> > possible to delay one transaction as long, as the other transaction
> > writing into the database. Then, if done, the delayed transaction
>
> Enlighten me, folks:
>
> wot is the difference between "delaying" a transaction
> and making it wait on a lock?
>
> <jeez...>

In one, the data is prevented from being accessed. In the other, the transaction is prevented from even processing. Wow. That's the secret!!!! But I suppose that the end user couldn't care less what is happening under the covers just so long as the ACID properties of transactions are held true.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"