Scott Hess wrote:
On 7/26/07, Richard Klein <[EMAIL PROTECTED]> wrote:
According to the Mozilla article referenced above, it's even worse than
that: *All* cache pages, dirty or not, are freed at the end of *every*
transaction, even if the transaction consisted of only read operations.
I believe this is no longer true, as of a couple months ago. Now
SQLite tracks whether any other database connection has written data,
and doesn't invalidate the pages if nobody else is writing.
I think this is completely orthogonal to shared cache.
-scott
A few questions:
o Is this behaviour general or just in shared cache mode? You imply
that it is the general case.
o If it is general, how does it detect a stale cache? By an indicator
on the file?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
