|Subject||Re: Firebird Restarting part 2|
> Read only: yes. But !!! Read Committed for reports is terribleAmen!
> !!! Reports should always use a snapshot transaction (Concurrency
> isolation) to avoid getting discrepancies due to database state
> changing during execution!
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.