On 7/15/2011 2:15 PM, Steven E. Harris wrote: > I'd like to understand that better so as to figure out whether using > shared-cache mode is appropriate for my application. My motive had been > increased concurrency due to finer-grained locking, but given that this > part of my application is focused solely on writing in batches, which > multiple threads looking to write to different tables concurrently, your > response thus far says that shared-cache mode isn't going to help with > that contention.
To the best of my knowledge, there is simply no way in SQLite to write to two tables at the same time. That's pretty much what makes it "lite". -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
