Understanding Isolation Levels in Transaction
page 4 of 6
by SANJIT SIL
Feedback
Average Rating: 
Views (Total / Last 10 Days): 34166/ 102

Comparison of Isolation Levels

The isolation levels in the following table are arranged from the least degree of locking to the highest degree of locking. The default, ReadCommitted, is a good compromise for most transactions.

Isolation Level

Dirty Read

Non Repeatable

Phantom Data

Concurrency

ReadUncommitted

Yes

Yes

Yes

Best

ReadCommitted

No

Yes

Yes

Good

RepeatableRead

No

No

Yes

Poor

Serializable

No

No

No

Very Poor


View Entire Article

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2019 ASPAlliance.com  |  Page Processed at 2019-07-23 1:13:30 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search