Hi, I am trying to make sqlite available for concurrency within a process and multi-process.
1. Currently I am using the default Isolation level for Sqlite, which doesn't even allows me the multiple reads on the single table. What's the default isolation level and how can I change it? I tried to make the change in Begin Transaction statement but it threw an exception. 2. The other issue I am facing is that when I do a write long transaction on a table, all the read statements on other tables fail with the exception of "File Locked". How can I resolve this? 3. Did some search & read about Shared Cache, will this be the right choice for making Table Level Locking enabled to solve my previous issue? 4. If I have to enable Shared Cache, do I need to re-compile the code? I am using Sqlite driver with .net application. 5. Read about WAL, it gives the concurrency. But I think it gives concurrency by allowing dirty reads. Please correct me if I am wrong. Harnek _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
