Documentation Source Text

Check-in [cb6d3fd5fe]
Login

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

Overview
Comment:Update the change log to include the latest revisions.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: cb6d3fd5fe821c1542477158a7985f462815993c
User & Date: drh 2014-09-20 00:56:29
Context
2014-09-21
16:57
Fix typos. check-in: d2dedc4ab1 user: drh tags: trunk
2014-09-20
00:56
Update the change log to include the latest revisions. check-in: cb6d3fd5fe user: drh tags: trunk
2014-09-17
04:03
Add the "vsix" mimetype to the althttpd.c server. check-in: 881c3a3aed user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

16
17
18
19
20
21
22
23


24
25
26
27
28
29
30
31
32
33
34
35









36
37
38
39
40
41
42
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

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







|
>
>
|











>
>
>
>
>
>
>
>
>







16
17
18
19
20
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
48
49
50
51
52
53
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2014-11-?? (3.8.7)} {
<p><b>Performance Enhancements:</b>
<li>Dozens and dozens of micro-optimizations result in 10.5% more work for the same number
    of CPU cycles relative to the previous release. 
    The cumulative performance increase since [version 3.7.17] is 50.2%.
    (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
    occur inside of [CAST] operators.
<li>Added new interfaces with 64-bit length parameters:
    [sqlite3_malloc64()],
    [sqlite3_realloc64()],
    [sqlite3_bind_blob64()],
    [sqlite3_result_blob64()],
    [sqlite3_bind_text64()], and
    [sqlite3_result_text64()].
<li>Added the new interface [sqlite3_msize()] that returns the size of a memory allocation
    obtained from [sqlite3_malloc64()] and its variants.
<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