On 3/14/2014 12:42 PM, Sandu Buraga wrote:
For write operations the SQLite needs to lock the entire database file, using WAL the granularity is improved and the locks are at table level.
False. Which part of the documentation led you to believe that? You might be thinking of shared cache mode ( http://www.sqlite.org/sharedcache.html )
The locking is at the file level either way. The difference is that, with roll-back journal, you can have multiple readers OR a single writer at any given time. With WAL journal, you can have multiple readers AND a single writer.
I am asking this because I have scenario with one writer and 2 readers, and I am getting 'database table is locked' errors.
Are you turning on shared cache mode, by any chance? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
