Hi,

At October 24, 2005, 4:34 PM, Dmitri Kouzmenko wrote:

p>> Aw, come on! That's just semantics, whether we
p>> call it MVCC, MGA or record-shadowing or
p>> record-versioning or Row Versioning. 8-)

> Look at another point. Someone who invented
> MVCC talks - "we support MVCC, other support...
> but does FB supports MVCC? No, it supports
> something named MGA. But we invented
> MVCC, are we not the best?".

And, reading some of MS-SQL 2005 notes on snapshot transaction
(http://msdn.microsoft.com/SQL/2005/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5snapshotisol.asp)
does show some possible problems. It's mentioned that the snapshot
isolation level is a database setting. And, they also warn that using
the multi-versioning feature will cause a slow down, except for
performing updates where one transaction will not block another.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)