Subject | Re: [IB-Architect] Isolation level implemetation |
---|---|
Author | Toni Martir |
Post date | 2000-12-07T18:48:10Z |
> If I understand, you want a transaction mode that will not interfereWhat does it mean run as "pre-committed", how can I start a transaction that
> with garbage collection. Most of the work has been done make read-only
> read-committed transactions run as "pre-committed" so they don't affect
> garbage collection.
don't affect the OAT in Interbase 6?
>Read-write read-committed transactions could beRead-write transactions should be always short in time because modified
> made not to affect the Oldest Active Transaction, but would require a
> different mechanism.
records are locked for write by other transactions.
The main problem becomes when the client operation is interactive (the user
must clic to fetch next row), the user can go to make a coffee or go
vacation and garbage collection is not done.
> Serializing write transactions is not an option. Table locking is badI understand the way to do it now is table reservation. It has the aditional
> enough - locking the entire database is serious overkill.
work of reserving/unreserving new touched tables when the programmer
modifies the client application.
Are this transaction always serializable?
- Snapshot, read
- Snapshot, write, table reservation of tables to write.
Or I must use also table stability for write transactions?
Is table stability the equivalent to SQL92 serializable isolation level?
Thanks