On Tue, Mar 11, 2014 at 11:13 AM, RSmith <rsm...@rsweb.co.za> wrote: > > 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)? > There is one writing thread (every 5 minutes). The one writing thread writes in the same database, but it is on a different table.
> > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users