Documentation Source Text

Check-in [c9e67374a1]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix the version number of Ubuntu.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c9e67374a145f5c1e2b54ace0245ae624debb576
User & Date: drh 2014-09-05 12:50:40.848
Context
2014-09-08
12:09
Add the OpenDocument as SQLite case study. (check-in: 2c57c78315 user: drh tags: trunk)
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)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34


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








|








20
21
22
23
24
25
26
27
28
29
30
31
32
33
34


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 13.10 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
︙︙