https://docwiki.embarcadero.com/RADStudio/Athens/en/Connect_to_SQLite_database_(FireDAC)

LockingMode    
Sets the database connection locking-mode. The value is one of the following:

Normal -- This mode gives multi-user access to database files.
Exclusive -- This mode gives maximum performance.
The default value is Exclusive, because it allows you to get maximum read/write speed for single user applications.

 


PRAGMA read_uncommitted=true