Subject RE: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...
Author Svein Erling Tysvær
> 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