"Dennis Volodomanov" <dennis.volodoma...@conceiva.com> wrote in message news:8501919721c3de4c81bca22846b08721a3f...@lazarus.conceiva.com >> Wrong. Statements on the same connection certainly see changes made >> on that connection, committed or otherwise. >> >> Are you talking about the same connection, or two different >> connections in shared cache mode? You started describing the latter, >> but now keep mentioning the former. Which way is it? > > 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. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users