Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Further tweaks to the change log for 3.8.7. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
e3957c53b1cab667f791bb37622dfec9 |
User & Date: | drh 2014-09-01 18:31:33.322 |
Context
2014-09-05
| ||
12:50 | Fix the version number of Ubuntu. (check-in: c9e67374a1 user: drh tags: trunk) | |
2014-09-01
| ||
18:31 | Further tweaks to the change log for 3.8.7. (check-in: e3957c53b1 user: drh tags: trunk) | |
18:16 | Add documentation about the threads pragma and the WORKER_THREADS compile-time options. Update the change log to include the latest performance numbers and mention of multi-threaded sorting. (check-in: 39b74ae928 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
21 22 23 24 25 26 27 | chng {2014-11-?? (3.8.7)} { <p><b>Performance Enhancements:</b> <li>Dozens of micro-optimizations result in 6.7% fewer CPU cycles needed to do the same amount work. (Measured using [http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the [http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on Ubuntu 10.13 x64 with gcc 4.8.1 and -Os. Your performance may vary.) | | | > > > > > | 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 | chng {2014-11-?? (3.8.7)} { <p><b>Performance Enhancements:</b> <li>Dozens of micro-optimizations result in 6.7% fewer CPU cycles needed to do the same amount work. (Measured using [http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the [http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on Ubuntu 10.13 x64 with gcc 4.8.1 and -Os. Your performance may vary.) <li>Provide the ability for the sorter to start and use auxiliary helper threads in order to increase real-time response. This feature is off by default and may be enabled using the [PRAGMA threads] command or the [SQLITE_DEFAULT_WORKER_THREADS] compile-time option. <li>Enhance the [skip-scan] optimization so that it is able to skip index terms that occur in the middle of the index, not just as the left-hand side of the index. <li>The query planner is now able to do a better job of understanding constants that occur inside of [CAST] operators. <p><b>New Features:</b> <li>Added the [SQLITE_LIMIT_WORKER_THREADS] option to [sqlite3_limit()] and [PRAGMA threads] command for configuring the number of available worker threads. <li>Added new options to the [command-line shell] for configuring auxiliary memory usage: --pagecache, --lookaside, and --scratch. <p><b>Bug Fixes:</b> <li>Fix a bug in the [partial index] implementation that might result in an incorrect answer if a partial index is used in a subquery or in a [view]. Ticket [http://www.sqlite.org/src/info/98d973b8f5|98d973b8f5] <li>Fix a bug in [sqlite3_trace()] that was causing it to sometimes fail to print an SQL statement if that statement needed to be re-prepared. Ticket [http://www.sqlite.org/src/info/11d5aa455e0d98f3c1e6a08|11d5aa455e0d98f3c1e6a08] |
︙ | ︙ |