dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnectionStringBuilder Class / JournalSizeLimit Property

JournalSizeLimit Property
Gets or sets the maximal size of the log file in bytes.
Syntax
'Declaration
 
Public Property JournalSizeLimit As Integer
 

Property Value

The maximal size of the log file in bytes.
Remarks

This setting may be useful if you use JournalMode set to JournalMode.Persist or Locking set to LockingMode.Exclusive. In these cases the rollback journal file may remain in the file-system after committing a transaction. If it is larger than the specified value after committing a transaction, it is truncated.

Negative values mean no limit. The default value is -1.

This property uses the corresponding SQLite PRAGMA - journal_size_limit.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also