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

2012-05-28 Thread Mohit Sindhwani
Hi Igor, On 29/5/2012 10:52 AM, Igor Tandetnik wrote: Mohit Sindhwani wrote: However, looking at this: http://www.sqlite.org/cvstrac/wiki?p=MultiThreading It has never been safe to use the same database connection simultaneously in multiple threads. That document is obsolete. It has been saf

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

2012-05-28 Thread Igor Tandetnik
Mohit Sindhwani wrote: > However, looking at this: > http://www.sqlite.org/cvstrac/wiki?p=MultiThreading > > It has never been safe to use the same database connection simultaneously in > multiple threads. That document is obsolete. It has been safe for a long time now. For details, see http://

[sqlite] Question about multi-threading with a read-only database

2012-05-28 Thread Mohit Sindhwani
Hi All, We have a read-only database (compiled with CEROD) that needs to be accessed from within the same program using multiple threads. Currently, we open the database once and all the threads use the sqlite3_db* to create their own personal prepared queries and run their queries. Howeve