Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Further tweaks to the change log for 3.8.7. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e3957c53b1cab667f791bb37622dfec9 |
| User & Date: | drh 2014-09-01 18:31:33 |
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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
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>Added 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
happy to occur inside of [CAST] operators.
<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]
|
| | > > > > > |
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]
|