I'm using an in-memory sqlite db via c# with a shared cache , and I have a few questions about how certain operations are handled.
How are multiple concurrent readers that share the same connection handled? Do I need to create a separate connection for each reader in order to keep these from running serially? Will writers on separate connections block the readers from running queries? I'm using PRAGMA read_uncommitted = true, but it still seems that queries are getting blocked intermittently. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users