(text/x-fossil-plain)
SQLite supports three different thread-safety models: See [http://www.sqlite.org/threadsafe.html].
The default is to serialize all accesses to the database.
Currently, System.Data.SQLite.Core offers no way to configure this threading mode.
It would be nice to be able to disable serialization in single-threaded applications, or to enable 'multi-threaded' mode in multi-threaded applications that only use one connection per thread anyway.
The benefit of supporting this would be improved performance for applications that need it. Since configuring this at run-time is already supported in the underlying C library, it merely needs to be exposed (perhaps as part of the connection string?).
|