> > It's multiple threads all using the same sqlite3* handle. I call > > sqlite3_enable_shared_cache(1); before opening the database and have > > "PRAGMA read_uncommitted=1;" right after opening the database. > > None of that has any effect as long as you only have one connection. > For > the cache to be shared, you need at least two connections to share it > between. So you may as well drop those call.
Yes, good point... I might compare performance differences in using a shared connection (multiple threads each opening its own copy of the database and sharing the connection) vs using the same database from those threads, unless such timings have already been done? Thanks! Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users