On 3 Nov 2011, at 5:44pm, Richard Hipp wrote: > On Thu, Nov 3, 2011 at 12:13 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> >> If I start getting contention issues (locks failing because of too many >> concurrent attempts at access) then I'll look into using some PRAGMAs, >> possibly switching to WAL. >> >> > Several points:
Fair enough. So if I have a database created with version 3.6.x, but are now using 3.7.3, all I need to convert it to WAL mode is to open it, then issue PRAGMA journal_mode = WAL , then close it properly, right ? (I can't update past 3.7.3 for SQLite as I know you're bursting to tell me: it's the version compiled into PHP 5.3.4 on that server. It will change when they update the version of PHP.) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users