On 13-Feb-20 23:38, Keith Medcalf wrote:
Correct. "memory" databases can only be shared between connections in the same process, and then
only by the sharedcache method. In effect, a "memory" database is nothing more than a cache, and
sharing it between connections means sharing the cache.
I have an app which is multithreaded. Sometimes during lengty inserts a
different thread (which only reads the database) sees part of the
updated data.
This would be solved by using transactions. However, during the
transaction the "reading" thread gets a 'database table is locked' error.
2 matches
Mail list logo
