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 connections to a database file WITHIN a process. 2. With Shared Cache Mode, Table level locking can be used to improve concurrency. 3. WAL mode increases concurrency by making Writes and Reads not blocking each other. Writes and Reads can be from one process or from multiple processes. Am I right with the above points? Thanks, Sean _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
