Subject Re: Firebird Restarting part 2
Author Adam
> Read only: yes. But !!! Read Committed for reports is terrible
> !!! Reports should always use a snapshot transaction (Concurrency
> isolation) to avoid getting discrepancies due to database state
> changing during execution!

Amen!

Read-Committed has very little to offer inside a MGA database. It is
predominantly a hack for locking databases to not simply curl their
feet up and die when someone runs a report touching a lot of data.
(MGA does not have this vulnerability).

OK, I will conceed that there may be some uses even in a good design,
but 99.99% of the time it is the wrong way to do things.

Adam