Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | branch-3.22 |
| Files: | files | file ages | folders |
| SHA3-256: |
015a7ffa9eb34f2339db165f4d1ec0b7 |
| User & Date: | drh 2018-03-20 13:15:15 |
Context
|
2018-03-23
| ||
| 22:56 | Copy the new CoC overview from trunk. (check-in: 3b828f75e4 user: drh tags: branch-3.22) | |
|
2018-03-20
| ||
| 13:15 | Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. (check-in: 015a7ffa9e user: drh tags: branch-3.22) | |
| 13:14 | Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. (check-in: fc5ba69bb7 user: drh tags: trunk) | |
|
2018-03-15
| ||
| 11:25 | Fix typos in the th3.html document. (check-in: 996754464c user: drh tags: branch-3.22) | |
Changes
Changes to pages/pragma.in.
1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 |
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>
<p>The TEMP schema always has synchronous=OFF since the content of
of TEMP is ephemeral and is not expected to survive a power outage.
Attempts to change the synchronous setting for TEMP are
silently ignored.
<p>See also the [fullfsync] and [checkpoint_fullfsync] pragmas.</p>
}
|
< < < < |
1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 |
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 TEMP schema always has synchronous=OFF since the content of
of TEMP is ephemeral and is not expected to survive a power outage.
Attempts to change the synchronous setting for TEMP are
silently ignored.
<p>See also the [fullfsync] and [checkpoint_fullfsync] pragmas.</p>
}
|