On Sat, 2 Jul 2011 12:27:07 +0800, "airwolf2026"
<airwolf2...@qq.com> wrote:
>Hello,
>
> Can current version support wal mode?
Yes.
> I try this by add
> "Pragram journal mode = wal;" in connection string;
> but it doesn't take effect?
> how can i do that ?
It's not something you do in a connection string, and your
spelling is not correct.
WAL mode is persistent, once you've set it, the database remembers
it for all future database connections, so you have to switch it
on just once, typically immediately after creating the database.
The way to do this is to use SQL:
PRAGMA jounal_mode=WAL;
http://www.sqlite.org/pragma.html#pragma_journal_mode
THe query parameters SQLite knows do not include journal_mode:
http://www.sqlite.org/uri.html#coreqp
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
