Thanks. Pasting the extract from the link below: -------------------------------------------------------------------------------- Note that the journal_mode for an in-memory database is either MEMORY or OFF and cannot be changed to a different value. An attempt to change the journal_mode of an in-memory database to any setting other than MEMORY or OFF is ignored. ---------------------------------------------------------------------------------
Our application is kind of heavily multi-threaded and required using sqlite to be used as an in memory database for caching purposes. Being multi-threaded requires read-write locking mechanism, and WAL seemed quite the thing for us. We are expecting high rate of Inserts and Selects simultaneously. Q. Well since WAL cannot be used with in-memory database, which other method do you all suggest one should use for providing better concurrency? Can using Shared Cache Mode be of use? http://www.sqlite.org/sharedcache.html Experts: Your comments please. Thanks & Regards, Sachin Gupta -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dustin Sallings Sent: Friday, December 31, 2010 1:08 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Using WAL? On Dec 30, 2010, at 10:42, Sachin Gupta wrote: > This is for setting the Journal Mode. But has the WAL mode been set properly? > How can we confirm this? Simon answered this question. > Also, Can WAL mode be used for In Memory Databases? > I am planning to use it in my application. I don't think this makes much sense. Where would the log live? The answer to all of your questions are in the docs here: http://sqlite.org/pragma.html#pragma_journal_mode -- dustin sallings _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
