Janke, Julian wrote: > PRAGMA journal_mode=WAL; > > Unfortunately, after these lines, the journal mode is not changed. > > -DSQLITE_OS_OTHER=1
Do you have mmap support? <http://www.sqlite.org/wal.html> says: | WAL normally requires that the VFS support shared-memory primitives. | The built-in unix and windows VFSes support this but third-party | extension VFSes for custom operating systems might not. But <http://www.sqlite.org/wal.html#noshm> says: | Use of WAL Without Shared-Memory | | Beginning in SQLite version 3.7.4, WAL databases can be created, read, | and written even if shared memory is unavailable as long as the | locking_mode is set to EXCLUSIVE before the first attempted access. In | other words, a process can interact with a WAL database without using | shared memory if that process is guaranteed to be the only process | accessing the database. This feature allows WAL databases to be | created, read, and written by legacy VFSes that lack the "version 2" | shared-memory methods xShmMap, xShmLock, xShmBarrier, and xShmUnmap on | the sqlite3_io_methods object. Regards, Clemens
