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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
2e695cb38031c631b1844c9eaac931a0 |
User & Date: | drh 2017-09-11 21:09:15.386 |
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%. |
︙ | ︙ |