Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarify wording about PRAGMA synchronous=NORMAL and WAL mode. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
7660cac647063256e35474929023abb1 |
| User & Date: | drh 2017-02-03 04:10:35 |
Context
|
2017-02-04
| ||
| 14:45 | Remove obsolete statements from the EXPLAIN QUERY PLAN documentation. (check-in: 735ffb4d2d user: drh tags: trunk) | |
|
2017-02-03
| ||
| 04:10 | Clarify wording about PRAGMA synchronous=NORMAL and WAL mode. (check-in: 7660cac647 user: drh tags: trunk) | |
|
2017-02-02
| ||
| 23:55 | Clarify the behavior of AUTOINCREMENT after an UPDATE. (check-in: f6e2eab4e7 user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 |
synchronized before each [checkpoint] and the database file is
synchronized after each completed [checkpoint] and the WAL file
header is synchronized when a WAL file begins to be reused after
a checkpoint, but no sync operations occur during most transactions.
^With synchronous=FULL in WAL mode, an additional
sync operation of the WAL file happens after each transaction commit.
The extra WAL sync following each transaction help ensure that
transactions are durable across a power loss, but they do not aid
in preserving consistency.
If durability is not a concern, then synchronous=NORMAL is normally
all one needs in WAL mode.</p>
<p>^The default setting is usually synchronous=FULL.
The [SQLITE_EXTRA_DURABLE] compile-time option changes the
default to synchronous=EXTRA.</p>
|
| | > |
1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 |
synchronized before each [checkpoint] and the database file is
synchronized after each completed [checkpoint] and the WAL file
header is synchronized when a WAL file begins to be reused after
a checkpoint, but no sync operations occur during most transactions.
^With synchronous=FULL in WAL mode, an additional
sync operation of the WAL file happens after each transaction commit.
The extra WAL sync following each transaction help ensure that
transactions are durable across a power loss. Transactions are
consistent with or without the extra syncs provided by
synchronous=FULL.
If durability is not a concern, then synchronous=NORMAL is normally
all one needs in WAL mode.</p>
<p>^The default setting is usually synchronous=FULL.
The [SQLITE_EXTRA_DURABLE] compile-time option changes the
default to synchronous=EXTRA.</p>
|