Subject Re: Why it's soo slow ? it's just a very simple select ...
Author nathanelrick
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
>