Subject | Re: Why it's soo slow ? it's just a very simple select ... |
---|---|
Author | nathanelrick |
Post date | 2012-03-09T17:05:45Z |
yes, isolation level is isc_tpb_read_committed + isc_tpb_rec_version so everything must be ok
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>
> > 3/ as i know readonly can stay open undefinitively without hurting the database
>
> Provided the isolation level also is READ COMMITTED. If you use SNAPSHOT as your isolation level, then even read-only transactions block garbage collection (at least, I cannot imagine how to keep a stable view of the database if you don't block it).
>
> HTH,
> Set
>