On Thu, 10 Nov 2005, Tony Caduto wrote:
>> Serializable is stricter and somehwat unusable in a multi-user, loaded
>> database, because only one transaction can run at any time. Let's say you
>> would have one long running serializable transaction encapsulating a
>> reporting query, this will cause other transactions to wait.
>>
>> There is a pretty good paper on discussing why it was a somewhat bad idea
> to
>> describe transaction isolation levels in terms of phenomena in the SQL
>> standard. This paper also describes transaction isolation levels for MVCC
>> databases. The paper is from 1995.
> http://www.cs.duke.edu/~junyang/courses/cps216-2003-spring/papers/berenson-etal-1995.pdf
>>
>> SNAPSHOT in Firebird isn't a SQL standard compliant REPEATBLE READ either.
>> SNAPSHOT in Firebird is between REPEATABLE READ and SERIALIZABLE, but
>> without blocking other transactions.
>
> Is this true? will SERIALIZABLE block all transactions on the whole server,
> or just on that one connection?
I don't believe so ... my understanding was that MVCC took care of any
blocking issues, since we are looking at a 'snapshot' or 'layer' of data,
based on the time you started the transaction ... other transactions can
still work on data while the SERIALIZABLE transaction is going on ...
The way I've thought about it is akin to going to a cash register to pay
for groceries ... you don't want prices to change part way through the
cashier ringing up your bill, but you also don't want to have the office
shut everyone off while they update the price list ... so the cash
register would be running the 'bill tally' in a SERIALIZABLE transaction,
so that the prices are based on when (s)he started to ring things up ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
