Subject | Re: [firebird-support] Re: Caching retention using a persistent dummy database connection? |
---|---|
Author | Ann W. Harrison |
Post date | 2007-09-13T16:33:31Z |
jeff_j_dunlap wrote:
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.
Cheers,
Ann
> --- In firebird-support@yahoogroups.com, "Ann W. Harrison" >I do know that a connection does not imply a transaction in
>> If the dumb connection is read-only, read-committed,
>> it won't block garbage collection.
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.
Cheers,
Ann