On 7 Aug 2018, at 1:54pm, Gerlando Falauto <gerlando.fala...@gmail.com> wrote:

> I just realized I'm using default settings... perhaps I should use WAL mode
> instead?

How important is it to you that SELECT gets up-to-date information ?  If a read 
happens at the same time as a write:

Normal mode: SELECT waits until the write is finished, then reads
   WAL mode: SELECT immediately returns data from before the write

(the above is simplified for short one-write one-read situations).

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to