On Dec 30, 2010, at 19:21, Sachin Gupta wrote:

> 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 


        In general, just don't just try to have a bunch of threads throwing 
stuff at the same data structure and expecting awesome goodness to fall out.

        Can you structure your application so that there's just one thread 
holding the state and you pass messages in and out to retrieve and mutate 
state?  I imagine this would be the shortest path to success and definitely the 
easiest to prove correct.

-- 
dustin sallings

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

Reply via email to