Questions tagged [isolation-level]

Isolation level defines what data an SQL transaction can view or access while other transactions work with the same data.

ACID standard defines 4 isolation levels - read uncommitted, read committed, repeatable read and serializable. The higher the isolation level is, the more is guaranteed that another transaction can't break yours, but the lower amount of concurrency the database can handle. MySQL and MSSQL support all isolation levels, while PostgreSQL and Oracle support only the 2 most common, read committed and serializable

Read uncommitted means that the transaction works with the latest data available. In this isolation level it's possible that a transaction reads data that is not yet committed and possibly will be rolled back and never exist.

Read committed is the most basic isolation level, which ensures that transactions only read data that is already saved. It is possible however for another transaction to modify the data after the first transaction has read it but before it has modified it.

Repeatable read ensures that any subsequent read of the data will return the same result as the first read, therefore eliminating the race condition described above.

Serializable ensures that transactions are run in such a way that the result is the same as they were run in sequence, not in parallel.

725 questions
-1
votes
4 answers

Need Help about ADO.Net Transaction

I develop C# window application with Microsoft SQL Server 2005 sp3. My Application has ploblem while one of client save Order Document. Another client cannot select data from Order table util saving process is complete. I used Transaction and…
Devman
  • 1
  • 1
-2
votes
1 answer

SQL Isolation level

We are using session isolation serializable in our application. The intended behavior is that when a user is going insert a new row, it should-should check for the presence of the row with the same key and update the same if row found. But I have…
-2
votes
2 answers

Transaction Isolation Level issue

I have been reading up on Transaction Isolation Levels and I am not sure I understand everything correctly. I need help. Please consider the following Csharp pseudo code: Using Stored procedure 1, open transaction Insert or update table 1 Using…
Ajit Goel
  • 4,180
  • 7
  • 59
  • 107
-2
votes
1 answer

Setting SQL Default Transaction Isolation Level

I want to have an application where the isolation level would ALWAYS be SNAPSHOT. If I want to use stored procedures for the application, how would I go about ensuring that the transaction level stays set to SNAPSHOT? Every time I closed the…
1 2 3
48
49