TLiteConnectionOptions.LockingMode Property

Used to specify the database locking mode: Exclusive or Normal.

property LockingMode: TLockingMode default DefValLockingMode;

Use the LockingMode property to specify the database locking mode: Exclusive or Normal.

lmExclusive - The database connection never releases file locks. The first time the database is read or written in this mode, a shared lock is obtained and held. Use this mode if you want to prevent other processes from accessing the database file, reduce the number of filesystem operations, or access WAL databases without using the shared memory.
lmNormal - The database connection unlocks the database file at the conclusion of each read or write transaction.

Note: Keep the default LockingMode=lmExclusive and Synchronous=smOff for the best perfomance.