On Sat, Nov 5, 2011 at 3:09 PM, Simon Slavin <slav...@bigfraud.org> wrote:

> I'm checking my understanding.  Please confirm, deny, or point out
> problems.
>
> I have a database file created with version 3.6.x, but are now using
> 3.7.3.  I don't use an weird PRAGMAs.  I can rely on other people not using
> the file while I convert.  All I need to do to convert it to WAL mode is
>
> open database
> PRAGMA journal_mode = WAL
> close database
>

The above is all you need to do.


>
> right ?  Or do I need to make a change of some kind before closing the
> database ?  Or did I get it entirely wrong ?
>
> (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
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to