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 | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
fc5ba69bb777f295276ece36128ca80b |
| User & Date: | drh 2018-03-20 13:14:41 |
Context
|
2018-03-22
| ||
| 12:01 | Updates to the change log. (check-in: 50c0768dbe user: drh tags: trunk) | |
|
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-19
| ||
| 13:46 | Document two new bug fixes in the change log. (check-in: 58f72e5776 user: drh tags: trunk) | |
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>
}
|