Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add the xBestIndex enhancement to the 3.21.0 change log. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
2e695cb38031c631b1844c9eaac931a0 |
| User & Date: | drh 2017-09-11 21:09:15 |
Context
|
2017-09-11
| ||
| 23:48 | Add the b899b6042f97f5 ticket fix to the change log. (check-in: 5257ab389b user: drh tags: trunk) | |
| 21:09 | Add the xBestIndex enhancement to the 3.21.0 change log. (check-in: 2e695cb380 user: drh tags: trunk) | |
|
2017-09-01
| ||
| 20:53 | Updates to the size and performance chart (check-in: 5e4cd244d1 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
<li> Improved de-quoting of column names for [CREATE TABLE AS] statements with
an aggregate query on the right-hand side.
<li> Fewer "stat()" system calls issued by the unix VFS.
<li> Query planner enhancements:
<ol type="a">
<li> Enhanced the [LIKE optimization] so that it works with an ESCAPE clause.
</ol>
<li> Enhanced the [CSV virtual table] so that it accepts the last row of
input if the final new-line character is missing.
<li> Remove the rarely-used "scratch" memory allocator. Replace it with the
[SQLITE_CONFIG_SMALL_MALLOC] configuration setting that gives SQLite
a hint large memory allocations should be avoided when possible.
<li> Added the swarm virtual table to the existing union virtual table extension.
<li> Miscellaneous [microoptimizations] reduce CPU usage by about 2.0%.
|
> > |
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
<li> Improved de-quoting of column names for [CREATE TABLE AS] statements with
an aggregate query on the right-hand side.
<li> Fewer "stat()" system calls issued by the unix VFS.
<li> Query planner enhancements:
<ol type="a">
<li> Enhanced the [LIKE optimization] so that it works with an ESCAPE clause.
</ol>
<li> Pass information about !=, IS, IS NOT, NOT NULL, and IS NULL constraints
into the [xBestIndex] method of virtual tables.
<li> Enhanced the [CSV virtual table] so that it accepts the last row of
input if the final new-line character is missing.
<li> Remove the rarely-used "scratch" memory allocator. Replace it with the
[SQLITE_CONFIG_SMALL_MALLOC] configuration setting that gives SQLite
a hint large memory allocations should be avoided when possible.
<li> Added the swarm virtual table to the existing union virtual table extension.
<li> Miscellaneous [microoptimizations] reduce CPU usage by about 2.0%.
|