Documentation Source Text

  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

  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