Re: [sqlite] Question about multi-threading with a read-onlydatabase

2012-05-29 Thread Mohit Sindhwani
Hi Simon, On 29/5/2012 7:36 PM, Simon Slavin wrote: It might be worth pointing out that the creator of SQLite feels that threads are evil. In fact it's in the FAQ, together with a pointer to the standard work on the subject (which I have never managed to understand all the way through):

Re: [sqlite] Question about multi-threading with a read-onlydatabase

2012-05-29 Thread Simon Slavin
On 29 May 2012, at 8:00am, Mohit Sindhwani wrote: > Hi Igor, > > [snip] > > Thank you very much for the clarification. I guess we'll move to the > multi-threaded mode in a later release. It might be worth pointing out that the creator of SQLite feels that threads are evil. In fact it's in

Re: [sqlite] Question about multi-threading with a read-onlydatabase

2012-05-29 Thread Mohit Sindhwani
Hi Igor, On 29/5/2012 11:41 AM, Igor Tandetnik wrote: Multi-thread. In this mode, SQLite can be safely used by multiple threads provided that no single database connection is used simultaneously in two or more threads. Yes. But note that the default mode is "serialized". You must explicitly

Re: [sqlite] Question about multi-threading with a read-onlydatabase

2012-05-28 Thread Igor Tandetnik
Mohit Sindhwani wrote: > On 29/5/2012 10:52 AM, Igor Tandetnik wrote: >> That document is obsolete. It has been safe for a long time now. For >> details, see http://www.sqlite.org/threadsafe.html > > Thank you very much. However, reading this page also, it says: > >> Multi-thread. In this mode