Subject | Re: [IB-Architect] Isolation level implemetation |
---|---|
Author | Ivan Prenosil |
Post date | 2000-12-11T16:20:45Z |
> I think adding new trasaction isolation levels to Interbase is a good think:The reason why I would like to see Read Uncommitted isloation level
>
> 1- Less isolation level than read_commited/record_version,
> - somethink like read uncommited, I know interbase has allways a commited
> record, but I want this isolation level to not affect the Oldest
> Interesting Transation.
is to allow db administrator to see "who the hell is blocking that record
by updating it and is not about to commit/rollback the change !@#$% ?".
(just add before update trigger to store username into record)
Perhaps it was planned to implement such isolation level,
because IB will accept command
SET TRANSACTION READ UNCOMMITTED
(but behaves like Read Committed No Record_Version, I think)
Ivan
prenosil@...