Hi Kees , Thanks for reply,Yes the 'PRAGMA ' is my fault to'program',i use the C# wrapper aka "System.Data.Sqlite.dll",When I use it to open a sqlite.db,the sqlite openned in the normal mode(PRAGMA jounal_mode='Delete',I had downloaded the newest version ,my question is current release 'System.Data.Sqlite.dll' can support wal mode?
Thanks airwolf2026 ------------------ Original ------------------ From: "Kees Nuyt"<[email protected]>; Date: Sat, Jul 2, 2011 04:52 PM To: "sqlite-users"<[email protected]>; Subject: Re: [sqlite] current version support wal mode? On Sat, 2 Jul 2011 12:27:07 +0800, "airwolf2026" <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
