Subject | Re: [Firebird-Architect] Read Committed No Wait transactions |
---|---|
Author | Ivan Prenosil |
Post date | 2004-09-22T19:00:40Z |
I do not remember exact details, but Nickolay used no_record_versions
to solve some problems in heavy contention environment
(basically, without it nobody was able to do any useful work
because of constant lock conflicts/deadlocks)
Ivan
to solve some problems in heavy contention environment
(basically, without it nobody was able to do any useful work
because of constant lock conflicts/deadlocks)
Ivan
> From: "Ann W. Harrison"
> At 02:35 PM 9/21/2004, steve summers wrote:
>
> >The answer to this confusion is the "Rec_Version" flag. In IBExpress, if you
> >click on the "Read Committed" radio button, you get read_committed,
> >rec_version, and nowait flags. The IB6 API Guide says
>
> Yes, that's it. No record_version is the default, which
> makes some sense if you're waiting for committed versions
> and absolutely must have the very latest, without regard
> to consistency. However, the existence of a transaction
> mode that considers a concurrent insert a fatal error continues
> to bug me.
>
> Regards,
>
>
> Ann