> Shared cache mode would be better named "persistent cache mode" because > its main effect is to permit one thread to not flush the cache after > each transaction. The people at Mozilla report that they use it and get > better throughput on small transactions.
You've probably read this. It's useful information for any performance minded developer using SQLite: http://developer.mozilla.org/en/docs/Storage:Performance Mozilla no doubt benefits from a shared cache, but its transaction throughput improvement is largely due to deferring all database write operations to a background thread, making the foreground database writes seem instantaneous. However, this lazy writing drops Durability in ACID. This is described in the above link. ____________________________________________________________________________________ Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545433 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------