Transaction Isolation Level Massive Number Of Writes
I may be talking nonsense but: Which isolation level is 'best' for lots of Threads running on lots of connections, executing lots of updates and writes using transactions? Or isol
Solution 1:
As a rule of thumb: the higher your isolation leven (higher meaning: more isolation) the more locks and overhead you get. So if you want to go as fast and as parallel as possible you want no isolation at all.
Of course this might destroy your business logic, so I think there really is no alternative to looking at all the isolation levels available and checking them against your requirements.
Post a Comment for "Transaction Isolation Level Massive Number Of Writes"