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

Reply via email to