On 2014/03/11 11:58, St. B. wrote:
I still have a question. Since I have many threads (between 100 and 200) that do reading on the table that has the R Tree, and 1 thread that will write to another table once every five minutes, is it normal that I get database is locked error on a regular basis? I was under the impression that read only is lock free in when doing multiple access, and that locks should only occur during the writes.
So to be sure - You have no threads at all writing to this DB? Just 200 that read often and 1 that reads every 5 minutes (and then writes to a completely different DB)?
You cannot get locked errors then. Unless maybe some of these reads happen inside a transaction that is exclusive. Or a pragma that locks or does some function that requires a lock is called.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users