Simon, >From what I gathered on the web site, WAL is a state of how the engine works, not a type of database file. So the pragma needs to be set on each connection. The issue comes from the fact the SQLite.net version of SQLite is the destination for the logging system log4net. The log4net system only allows for a connection string and statement to insert a new log entry. There is no way to set the pragma upon opening the connection. With the framework being a logging system on top of .Net, the framework will manage the actual open/close of the DB, so setting the pragma outside of log4net won't really work either. The best way is to hard code SQLite source code to default to WAL all the time.
Sam On Thu, Jan 6, 2011 at 5:32 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Jan 2011, at 9:32pm, Sam Carleton wrote: > > > I looked through the source code to figure out how to default the > > journal_mode to WAL > > Default under what conditions ? A new database file ? A new connection ? > > Create a new database file, and execute > > PRAGMA journal_mode > > See what answer you get. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
