Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the change log to comment on the NOT NULL and CHECK constraint optimization. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
83657094beaddb3d56b458e8147fdfcb |
| User & Date: | drh 2016-02-10 19:16:14 |
Context
|
2016-02-12
| ||
| 05:18 | Merge changes from the 3.10 branch. check-in: 09a0fd52d7 user: drh tags: trunk | |
|
2016-02-10
| ||
| 19:16 | Update the change log to comment on the NOT NULL and CHECK constraint optimization. check-in: 83657094be user: drh tags: trunk | |
| 13:51 | Merge download page enhancements from the 3.10 branch. check-in: dd43be4bec user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
<li>Added the [FTS5 detail option].
<li>Added the "EXTRA" option to [PRAGMA synchronous] that does a sync of the
containing directory when a rollback journal is unlinked in DELETE mode,
for better durability. The [SQLITE_EXTRA_DURABLE] compile-time option enables
[PRAGMA synchronous=EXTRA] by default.
<li>Enhanced the [query planner] so that it is able to use
a [covering index] as part of the [OR optimization].
<li>Many micro-optimizations, resulting in a library that is both smaller
and faster than the previous release.
<p><b>Enhancements to the [command-line shell]:</b>
<li>By default, the shell is now in "auto-explain" mode. The output of
[EXPLAIN] commands is automatically formatted.
<li>Added the ".vfslist" [dot-commands|dot-command].
<li>The [SQLITE_ENABLE_EXPLAIN_COMMENTS] compile-time option is now turned
on by default in the standard builds.
<p><b>Enhancements to the [TCL Interface]:</b>
|
> > | | |
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
<li>Added the [FTS5 detail option].
<li>Added the "EXTRA" option to [PRAGMA synchronous] that does a sync of the
containing directory when a rollback journal is unlinked in DELETE mode,
for better durability. The [SQLITE_EXTRA_DURABLE] compile-time option enables
[PRAGMA synchronous=EXTRA] by default.
<li>Enhanced the [query planner] so that it is able to use
a [covering index] as part of the [OR optimization].
<li>Avoid recomputing [NOT NULL] and [CHECK constraints] on unchanged
columns in [UPDATE] statement.
<li>Many micro-optimizations, resulting in a library that is
faster than the previous release.
<p><b>Enhancements to the [command-line shell]:</b>
<li>By default, the shell is now in "auto-explain" mode. The output of
[EXPLAIN] commands is automatically formatted.
<li>Added the ".vfslist" [dot-commands|dot-command].
<li>The [SQLITE_ENABLE_EXPLAIN_COMMENTS] compile-time option is now turned
on by default in the standard builds.
<p><b>Enhancements to the [TCL Interface]:</b>
|