Re: [sqlite] Concurrency

2012-04-30 Thread Sean Cui
Database Subject: Re: [sqlite] Concurrency On Mon, Apr 30, 2012 at 8:10 PM, Sean Cui wrote: > Here is a simple scenario to explain what the OP meant: > > Under WAL mode, > > In connection A, we issue SQL "UPDATE Employee SET Salary=0" to SQLite. > > While the comm

Re: [sqlite] Concurrency

2012-04-30 Thread Sean Cui
Here is a simple scenario to explain what the OP meant: Under WAL mode, In connection A, we issue SQL "UPDATE Employee SET Salary=0" to SQLite. While the command is executing, from another connection, we issue "SELECT Salary FROM Employee". In this case, even under WAL, the SELECT command will

[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