> Could you please explain what you meant in this line? >> Of course I don't consider option of concurrency from >> different processes.
I guess I meant that my above words are related to the case when you access the database from the same process, and if one talks about different processes it's a little bit different story. But to be honest it's really hard to remember what I meant after 2 months... :) Pavel On Wed, Jun 9, 2010 at 7:04 AM, Navaneeth Sen B <[email protected]> wrote: > Hi Pavel, > Could you please explain what you meant in this line? >> Of course I don't consider option of concurrency from >> different processes. > Thanks & Regards, > Sen > > > On 4/6/2010 8:33 PM, Pavel Ivanov wrote: >>> Can anyone confirm whether concurrent >>> access to an in-memory database is supported? >>> >> No, SQLite doesn't support full concurrent access to any database. The >> only concurrency you can earn is having on-disk database without >> shared cache (so actually having several copies of the database in >> memory). Of course I don't consider option of concurrency from >> different processes. >> >> >> Pavel >> >> On Tue, Apr 6, 2010 at 9:43 AM, Kent Boogaart<[email protected]> >> wrote: >> >>> Hi there, >>> >>> I've recently been struggling with concurrency for an in-memory >>> SQLite scenario. Basically, I want to be able to perform concurrent >>> reads against an in-memory SQLite database, thus using multiple CPUs >>> to good effect. >>> >>> I've tried everything I could think of and find in various blog posts >>> to get this working, but SQLite insisted on synchronizing the reads. >>> Switching from an in-memory DB to an on-disk DB immediately rectified >>> the issue. >>> >>> What I'm wondering is whether SQLite flat out doesn't support >>> concurrent access to an in-memory database, or perhaps whether I'm >>> just doing something wrong. Can anyone confirm whether concurrent >>> access to an in-memory database is supported? >>> >>> Thanks, >>> Kent >>> >>> _______________________________________________ >>> sqlite-users mailing list >>> [email protected] >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
