Hi,
First, I've a process A that do many inserts to the database and reads back from the database to verify. The writes are done in one DEFERRED transaction as data are not committed yet. While the first process running, another process B is launched to read from the database for display purposes. Process B will halts until the transaction ends. I expect process B able to read the old data and displays appropriately. But, process B seems to be blocked. Why is this so as I thought SQLite handle concurrency as in this case where there are multiple reads and one single write ? Please help. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
