Subject Re: [IBO] Transaction question
Author Geoff Worboys

> I'm using tiCommitted. So, if I understand you well,
> multiple users can read records, while 1 user is updating.

Yes, this is what they refer to as Interbase's multi-generational
architecture (MGA). Any updates posted to the dataset are written as
a new copy, and the old copy remains valid until the new copy is
committed. A reader of data should never experience a
lockout/deadlock from reading, because they can read an old version of
the record even if someone is currently updating it.

MGA one of the reasons for using Interbase versus some other systems.


Geoff Worboys
Telesis Computing