|Subject||Re: [firebird-support] Re: Firebird Restarting part 2|
>Michael,At 08:17 PM 29/12/2006, Nando wrote:
>M> I think that almost every report we make, are made with the
>M> read-comitted transaction.
>it should be *READ-ONLY* read committed.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!