Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: "Tony Rogerson" <tonyrogerson@xxxxxxxxxxxxxxxx>
- Date: Fri, 17 Feb 2006 17:05:29 -0000
"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@xxxxxxxxxxxx> wrote in message
news:1140137288.135215.86690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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...
.
- Follow-Ups:
- References:
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Mark Townsend
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Tony Rogerson
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Sybrand Bakker
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Tony Rogerson
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Mark Townsend
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Tony Rogerson
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- From: Noons
- Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- Prev by Date: Re: Copying the PL/SQL web toolkit
- Next by Date: Re: Copying the PL/SQL web toolkit
- Previous by thread: Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- Next by thread: Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- Index(es):