Re: C#, ADO.NET and MS-SQL
From: Jon Skeet [C# MVP] (skeet_at_pobox.com)
Date: 07/19/04
- Next message: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Previous message: Beeeeeeeeeeeeves: "RE: how to get a collection of correct directory by RegEx"
- In reply to: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Next in thread: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Reply: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 15:13:35 +0100
Daniel Billingsley <dbillingsley@NO_durcon_SPAAMM.com> wrote:
> Jon, I recently did some investigation into this very topic. It turns out,
> no, read transactions won't prevent the kind of data "error" you describe,
> as Sql Server read transactions (as per ANSI) only lock each row as the
> cursor reads it.
Yuk. That's really horrible...
> Apparently Oracle works the way you describe, by using a sort of change log
> and using it to retrieve the state of each requested row as of the time you
> started the transaction. I was told that's one of the reasons why
> performance tuning is so critical and demanding for Oracle (you can imagine
> the work required to accomplish such a thing).
Yup.
> I would imagine this has been a barrier to Sql Server's use in areas like
> financial, where read integrity as you described is everything to the
> application.
I would have thought integrity would be vital to pretty much *every*
application though!
> Yukon is supposed to have a similar option per Feb 2004 MSDN magazine.
Goodo - I'll see if I can have a look at that.
-- Jon Skeet - <skeet@pobox.com> http://www.pobox.com/~skeet If replying to the group, please do not mail me too
- Next message: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Previous message: Beeeeeeeeeeeeves: "RE: how to get a collection of correct directory by RegEx"
- In reply to: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Next in thread: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Reply: Daniel Billingsley: "Re: C#, ADO.NET and MS-SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
