On Wed, Jan 26, 2011 at 10:56 AM, Ian Hardingham <i...@mode7games.com> wrote:
> Hey guys. > > I am under the impression that there is no concurrent access to a single > SQLite DB. Ie if thread A is performing a query, and thread B trys to > query, it will block until thread A is finished, no matter the query. > > 1. Is this correct? > It is true if A and B are attempting to share the same database connection. Access to the database connection is protected by a mutex. > > 2. Are there any fairly general workarounds of any kind? > Use a separate database connection for each thread. Or better: Use processes instead of threads, as threads are evil. > > Thanks, > Ian > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
