Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the change log and the speed-and-size graph. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
03fde5ae272314a947e5f3e2eccfd307 |
User & Date: | drh 2017-05-02 18:46:38.306 |
Context
2017-05-04
| ||
19:44 | Add the "35% Faster Than The Filesystem" document. (check-in: fd906f77ce user: drh tags: trunk) | |
2017-05-02
| ||
18:46 | Update the change log and the speed-and-size graph. (check-in: 03fde5ae27 user: drh tags: trunk) | |
01:31 | Fix typo. (check-in: f230c5ce7d user: mistachkin tags: trunk) | |
Changes
Changes to misc/speed-size-graph.ods.
cannot compute difference between binary files
Changes to pages/changes.in.
︙ | ︙ | |||
17 18 19 20 21 22 23 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } | | > > > > > > > > > | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-06-00 (3.19.0)} { <li> When using an index on an expression, try to use expression values already available in the index, rather than loading the original columns and recomputing the expression. <li> Enhance the [flattening optimization] so that it is able to flatten views on the right-hand side of a LEFT JOIN. <li> Use [replace()] instead of [char()] for escaping newline and carriage-return characters embedded in strings in the .dump output from the [command-line shell]. <li> Avoid unnecessary foreign key processing in UPDATE statements that do not touch the columns that are constrained by the foreign keys. <li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct entry using the index rather that stepping through rows, when an appropriate index is available. <li> Avoid unnecessary invalidation of [sqlite3_blob] handles when making changes to unrelated tables. <li> Transfer any terms of the HAVING clause that use only columns mentioned in the GROUP BY clause over to the WHERE clause for faster processing. <li> Reuse the same materialization of a VIEW if that VIEW appears more then once in the same query. <li> Enhance [PRAGMA integrity_check] so that it identifies tables that have two or more rows with the same [rowid]. <p><b>Bug Fixes:</b> <li> Fix a problem in [REPLACE] that can result in a corrupt database containing two ore more rows with the same [rowid]. Fix for ticket [https://www.sqlite.org/src/info/f68dc596c4e6018d|f68dc596c4e6018d]. <li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent [VACUUM] to behave suboptimally. <li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with foreign keys on [WITHOUT ROWID] tables. <li> Disallow leading zeros in numeric constants in JSON. Fix for ticket [https://www.sqlite.org/src/info/b93be8729a895a528e2|b93be8729a895a528e2]. <li> Disallow control characters inside of strings in JSON. Fix for ticket |
︙ | ︙ |