In Firebird-general@yahoogroups.com,
Dmitri Kouzmenko <kdv@i...> wrote:

> >> - InterBase have MGA since 1985

> MT> v1, correct?

> Maybe, only Jinm can tell :-)

Maybe you mean Jinn (look it up!)?

> MT> No earlier. Reading in the newsgroup, they say since v3 or v4
> MT> or it got extended MVCC since v4.

> what do you mean by v3 or v4?

I would like some clarification of this. I think
(from what I read somewhere but can't find
again) that they *_started_* to implement
MGA in 4 but didn't finish till 7?

> MT> Although I thought it was around v7 ...

> not sure. I know that moving from v7 to v8
> extended database size up to 15-25% by
> metadata versioning and record versions
> (I know that versions stored in transacion log).

Is it not called the redo log?


(SQL Server Yukon)

> MT> Not entirely sure -- it has _something_ like MGA.

> I have carefully read some local articles, and seems that
> MS SQL 2005 versioning copied 95% of IB/FB versioning.

It appears that M$oft are definitely introducing
some/all of what IB/FB have had for over
20 years.

> MT> They have MVCC/MGA in its InnoDB storage system.

> already? I'm not sure about their transaction support,
> so versioning here does not mean so much. I'm wrong?

Check out this

http://www.phpbbserver.com/
phpbb/viewtopic.php?t=537&mforum=
dizwellforum

Seems pretty similar to IB/FB to me.



Paul...

> Dmitri Kouzmenko, www.ibase.ru, (095) 953-13-34