mORMot Open Source

amsdev

Member

Registered: 2011-09-16

Posts: 23

Specific sqlite settings

Hi,

I try to migrate from DevArt LiteDAC to SynSqlite3/SynDB because of performance issues.

My current server code (with LiteDAC) use Sqlite dll with this compile settings:

SQLITE_CASE_SENSITIVE_LIKE
SQLITE_THREADSAFE=2

and this runtime settings:

SQLITE_OPEN_SHAREDCACHE
PRAGMA read_uncommitted = true;
BusyTimeout = 15 (seconds)

My server create sqlite connection for each client request (each request in their own thread) and use BEGIN IMMEDIATE for writing transactions.

Does SynSqlite3/SynDB will works with SQLITE_THREADSAFE=2 ? And it's possible to set SQLITE_OPEN_SHAREDCACHE and PRAGMA read_uncommitted = true somehow before connection ?

And final question: is TSQLDBSQLite3ConnectionProperties.MainSQLite3DB.BusyTimeout works as expected ?

Thanks for help !