Hi, It seems that following a vacuum on a wal-enabled database, the journal mode reverts to delete? Is this meant to happen? I couldn't find this stated as such in the documentation at www.sqlite.org/wal.html.
$ sqlite3 test.db SQLite version 3.7.0 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma journal_mode=wal; wal sqlite> create table t1 (i); sqlite> vacuum; sqlite> select * from t1; sqlite> pragma journal_mode; wal sqlite> .exit $ sqlite3 test.db SQLite version 3.7.0 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select * from t1; sqlite> pragma journal_mode; delete sqlite> .exit Is it possible to ensure the database stays in wal mode? Thanks Andy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users