On Sat, 6 Aug 2016 17:03:30 -0400 Richard Hipp <drh-czdrofg0bjidnm+yrof...@public.gmane.org> wrote:
> Doing "PRAGMA journal_mode=WAL;" on your database (just once, perhaps > from a command-line shell) will fix this for you. I read in the documentation: The WAL journaling mode uses a write-ahead log instead of a rollback journal to implement transactions. The WAL journaling mode is persistent; after being set it stays in effect across multiple database connections and after closing and reopening the database. A database in WAL journaling mode can only be accessed by SQLite version 3.7.0 or later. So this 'setting' is stored in the database file? Is it enough to do the PRAGMA when the database is created? Thanks, Levente -- 73 de HA5OGL Op.: Levente _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users