Re: [sqlite] questions regarding WAL and Shared Cache Mode

2012-04-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/04/12 14:52, Sean Cui wrote: > 1. The main purpose of Shared Cache Mode is to enable multiple > connections to a database file WITHIN a process. No, it is to save some memory. You can already open up multiple connections to the same or dif

[sqlite] questions regarding WAL and Shared Cache Mode

2012-04-30 Thread Sean Cui
Hello, this is my first question in the Sqlite mailing list: I am currently investigating concurrency in SQLite. I found two related topics: WAL and Shared Cache Mode. Below is a list of my understandings regarding them: 1. The main purpose of Shared Cache Mode is to enable multiple connecti