Hi, 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. Is it possible to get a better granularity, for example for a group of rows or even more to row level?
I am asking this because I have scenario with one writer and 2 readers, and I am getting 'database table is locked' errors. The write statements: INSERT, INSERT OR UPDATE, DELETE are encapsulated in a transaction and I am using WAL mode. Regards Sandu _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
