Menu
In a large business, should i use ReadCommitted or ReadUncommited Transaction Isolation Level by default when using NHibernate ?
By using ReadCommitted isolation, i've been facing in some locking on SELECT (Query) statements that become slow.
855
Serializable is the highest isolation level that protects transactions from all types of concurrency phenomena.
To set the transaction isolation level, use an ISOLATION LEVEL level clause. It is not permitted to specify multiple ISOLATION LEVEL clauses in the same SET TRANSACTION statement. The default isolation level is REPEATABLE READ . Other permitted values are READ COMMITTED , READ UNCOMMITTED , and SERIALIZABLE .
The SERIALIZABLE isolation level provides the most risk of blocking, but the lowest risk of lost data.
Two-phase locking is the most common transaction concurrency control method in DBMSs, used to provide both serializability and recoverability for correctness.
Well, if you're using SqlServer and have problems with ReadCommitted timeouts/locks, this is easily explainable. You probably just have to run this:
ALTER DATABASE your_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;
ALTER DATABASE your_db SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE your_db SET MULTI_USER;
try this and then retest your readcommitted approach. I would stick to it.
141
The core of the question:
Should i use ReadCommitted or ReadUncommited Transaction Isolation Level ?
Well, they can give different results. So you're actually asking:
Can I use use different result-sets when that is faster?
The answer depends on the application, only you can decide. But in general customers, especially large businesses, are not very tolerant to this.
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
