Re: Idea for concurrent transactions
From: Paul <paul_at_not.a.chance.ie>
Date: Thu, 18 Mar 2004 18:56:15 -0000
Message-ID: <MPG.1ac4010dfb7951a198990c_at_news1.eircom.net>
Date: Thu, 18 Mar 2004 18:56:15 -0000
Message-ID: <MPG.1ac4010dfb7951a198990c_at_news1.eircom.net>
ed.prochak_at_magicinterface.com says...
> > I believe that Informix uses it, and also Oracle some of the time.
> Just an FYI, ORACLE has used Multiversioning for a LONG time. I believe they
> were the first to do it. At the time I first studied this, interbase was the
> only other DBMS to also used MV.
I'm certain that PostgreSQL also uses it, or did you only mean commercial databases?
> MV is why ORACLE is much better with large transaction volumes and many
> simultaneous sessions/connections than most other products. Locking is just a
> painful way of controlling access.
My understanding is that Oracle uses a combination depending on the circumstances.
Paul...
> ed
-- plinehan y_a_h_o_o and d_o_t com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. "XML avoids the fundamental question of what we should do, by focusing entirely on how we should do it." quote from http://www.metatorial.comReceived on Thu Mar 18 2004 - 19:56:15 CET