Subject | Re: [firebird-support] Re: Firebird Restarting part 2 |
---|---|
Author | Helen Borrie |
Post date | 2006-12-29T09:37:48Z |
>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!
./heLen