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

In This Topic
    JournalSizeLimit Property
    In This Topic
    Gets or sets the maximal size of the log file in bytes.
    Syntax
    'Declaration
     
    Public Property JournalSizeLimit As Integer
    public int JournalSizeLimit {get; set;}

    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