|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 databaseProvided 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).