On Oct 22, 2008, at 11:32 PM, Hynes, Tom wrote: > 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?
The pragma documentation is out of date. Pager caches may now be shared between connections opened and used by different threads. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
