System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: a39cd89d85fb2a23bf028b489c36370457a0ed12
Title: Allow configuration of threading mode
Status: Open Type: Feature_Request
Severity: Important Priority: Medium
Subsystem: Integration_Via_PInvoke Resolution: Under_Review
Last Modified: 2014-08-01 18:42:23
Version Found In: 1.0.93.0
User Comments:
anonymous added on 2014-08-01 18:19:29:
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?).