Hello,

 

I noticed that the documentation for PRAGMA read_uncommitted in
http://www.sqlite.org/pragma.html says:

 

"...Cache sharing is enabled using the sqlite3_enable_shared_cache()
<http://www.sqlite.org/c3ref/enable_shared_cache.html>  API and is only
available between connections running the same thread. ..."

 

But, my impression from reading the sqlite3_enable_shared_cache()
<http://www.sqlite.org/c3ref/enable_shared_cache.html>  documentation is
that this is no longer true:

"... Cache sharing is enabled and disabled for an entire process. This
is a change as of SQLite version 3.5.0. In prior versions of SQLite,
sharing was enabled or disabled for each thread separately. ..."

If I am understanding this correctly, it seems that with 3.5.0 and
beyond connections do *not* have to live in the same thread to share a
cache.   So, is the PRAGMA documentation just out of date, or am I
misunderstanding this?

 

Thanks in advance!

 

Tom

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to