Subject Re: [firebird-support] Re: Caching retention using a persistent dummy database connection?
Author Ann W. Harrison
jeff_j_dunlap wrote:
> --- In, "Ann W. Harrison" >
>> If the dumb connection is read-only, read-committed,
>> it won't block garbage collection.

I do know that a connection does not imply a transaction in
the case of Firebird and that what's required to maintain
the cache is just the connection. The problem is that lots
of interfaces do equate connections and transactions, so it's
probably safer to start an read-only, read-committed transaction
that to try to maintain a connection without a transaction.