'Declaration Public Enum JournalMode Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
public enum JournalMode : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
'Declaration Public Enum JournalMode Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
public enum JournalMode : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
| Member | Description |
|---|---|
| Default | SQLite default Journal Mode is used. |
| Delete | In the Delete mode, the rollback journal is deleted at the conclusion of each transaction. |
| Memory | The MEMORY journaling mode stores the rollback journal in volatile RAM. It may be used to reduce disk I/O but that decreases database safety and integrity. If the application using SQLite crashes in the middle of a transaction in this mode, the database file may become corrupt. |
| Off | In this mode rollback journal is completely disabled. The ROLLBACK command does not work; it behaves in an undefined way. Don't use the ROLLBACK command in this mode. |
| Persist | In the Persist mode rollback journal file is not deleted when the transaction is commited. Its first block filled with zeroes to prevent other connections rolling back from this journal. May optimize performance on platforms where deleting or truncating a file is much more expensive than overwriting the first block of a file with zeros. |
| Truncate | In the Truncate mode rollback journal file is truncated instead of deleting when the transaction is commited. May be used for gaining better performance, because on many systems, truncating a file is much faster than deleting the file. |
| WAL | In the WAL mode, Write-Ahead Logging is used instead of the standard rollback journal. This means that when database data is updated, the original content is preserved in the database file, and the changes are appended into a separate WAL file and eventually are transferred to the database. |
System.Object
System.ValueType
System.Enum
Devart.Data.SQLite.JournalMode
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