Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | One of the disadvantages of WAL mode is that one cannot change the page_size. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
006ea9f849ebb23611f168bef302769f |
| User & Date: | drh 2016-09-13 22:45:37 |
|
2016-09-13
| ||
| 23:54 | Add links to android bindings, SDS, and Fossil to the documentation lists. (check-in: e581a20834 user: drh tags: trunk) | |
| 22:45 | One of the disadvantages of WAL mode is that one cannot change the page_size. (check-in: 006ea9f849 user: drh tags: trunk) | |
| 22:40 | Version 3.14.2 (check-in: bf7ce59b7b user: drh tags: trunk, release, version-3.14.2) | |
Changes to pages/wal.in.
53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
<li>There is an additional quasi-persistent "<tt>-wal</tt>" file and
"<tt>-shm</tt>" shared memory file associated with each
database, which can make SQLite less appealing for use as an
[application file-format].
<li>There is the extra operation of [checkpointing] which, though automatic
by default, is still something that application developers need to
be mindful of.
<li><s>WAL works best with smaller transactions. WAL does
not work well for very large transactions. For transactions larger than
about 100 megabytes, traditional rollback journal modes will likely
be faster. For transactions in excess of a gigabyte, WAL mode may
fail with an I/O or disk-full error.
It is recommended that one of the rollback journal modes be used for
transactions larger than a few dozen megabytes.</s>
|
> |
53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
<li>There is an additional quasi-persistent "<tt>-wal</tt>" file and
"<tt>-shm</tt>" shared memory file associated with each
database, which can make SQLite less appealing for use as an
[application file-format].
<li>There is the extra operation of [checkpointing] which, though automatic
by default, is still something that application developers need to
be mindful of.
<li>The [page_size] of the database file cannot be changed while in WAL mode.
<li><s>WAL works best with smaller transactions. WAL does
not work well for very large transactions. For transactions larger than
about 100 megabytes, traditional rollback journal modes will likely
be faster. For transactions in excess of a gigabyte, WAL mode may
fail with an I/O or disk-full error.
It is recommended that one of the rollback journal modes be used for
transactions larger than a few dozen megabytes.</s>
|