On 11 Oct 2011, at 4:51pm, Gal Waldman wrote: > On Tue, Oct 11, 2011 at 17:30, Simon Slavin <slav...@bigfraud.org> wrote: > >> How are you handling transactions ? Are all the changes involved in one >> update from one probe made inside one transaction ? Does this involve >> changing many rows ? > > Single transaction for all probes.
This may be keeping the database locked for long enough to block out other processes. If you change it to one transaction for each probe, the other processes may be able to sneak in between updates. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
