System.Data.SQLite

 Hi,

is it possible to give up some of the ACID compilance for performance gains in INSERT/UPDATE queries?

TIA,
Matthias

Setting Synchonous connection string parameter to Off makes much faster commit statements, at the risk of getting a corrupted database if a system failure occurs.

 Thank you for your hint. I'm experimenting with a connection string having "Synchronous = OFF;" included. If this parameter is included in the connection string, System.Data.SQLite sends "PRAGMA synchronous=OFF" to the SQLite core upon opening new connections. I'll look into the performance benefits of using this directive.

Regards, Matthias