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

Reply via email to