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