|Subject||Re: Why it's soo slow ? it's just a very simple select ...|
yes, isolation level is isc_tpb_read_committed + isc_tpb_rec_version so everything must be ok
--- In firstname.lastname@example.org, 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).