Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Fri, 17 Feb 2006 17:05:29 -0000
Message-ID: <dt4vo5$c1h$1$8302bc10@news.demon.co.uk>

> "both can be in force is necessary"?
>
> BOTH??????
> That tells me all I needed to know about how
> well it was implemented. As usual, no one
> has a CLUE what it's for so "let's just allow both"
> in case anyone asks...

How do you do this in Oracle then?

You have two applications, one requires you to implement the ANSI standard: snapshot isolation and the other the ANSI standard: read committed.

That's why they have engineered it to allow you to choose the isolation level you want.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message 
news:1140137288.135215.86690_at_g44g2000cwa.googlegroups.com...


> Tony Rogerson wrote:

>> The later is the transaction versioning that Oracle offers; the former 

>> just

>> gives the last committed value and doesn't block the writer; both can be 

>> in

>> force if necessary.

>>

>> --

>

>

> "both can be in force is necessary"?

>

> BOTH??????

> That tells me all I needed to know about how

> well it was implemented.  As usual, no one

> has a CLUE what it's for so "let's just allow both"

> in case anyone asks...

>

Received on Fri Feb 17 2006 - 11:05:29 CST