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 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
