Documentation Source Text

Check-in [70f4da8259]
Login

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

Overview
Comment:Add a line to the change log to describe an optimization that was added, forgotten, then remembered during the pre-release code inspection.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 70f4da82598f18e63e8f6da476677d2d5da305ed
User & Date: drh 2012-05-12 20:24:39.519
Context
2012-05-12
22:37
Fix a single spelling error. (check-in: 2cb9dc6d21 user: drh tags: trunk)
20:24
Add a line to the change log to describe an optimization that was added, forgotten, then remembered during the pre-release code inspection. (check-in: 70f4da8259 user: drh tags: trunk)
01:50
Fix a typo in the file format documentation. (check-in: c1bf8efee7 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
51
52
53
54
55
56
57


58
59
60
61
62
63
64
<li>Report the name of specific [CHECK] constraints that fail.
<li>In the command-line shell, use popen() instead of fopen() if the first
    character of the argument to the ".output" command is "|".
<li>Make use of OVERLAPPED in the windows [VFS] to avoid some system calls
    and thereby obtain a performance improvement.
<li>More aggressive optimization of the AND operator when one side or the
    other is always false.


<li>Add the [SQLITE_RTREE_INT_ONLY] compile-time option to force the
    [rtree | R*Tree Extension Module] to use integer instead of
    floating point values for both storage and computation.
<li>Enhance the [PRAGMA integrity_check] command to use much less memory when
    processing multi-gigabyte databases.
<li>New interfaces added to the test_quota.c add-on module.
<li>Added the ".trace" dot-command to the command-line shell.







>
>







51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<li>Report the name of specific [CHECK] constraints that fail.
<li>In the command-line shell, use popen() instead of fopen() if the first
    character of the argument to the ".output" command is "|".
<li>Make use of OVERLAPPED in the windows [VFS] to avoid some system calls
    and thereby obtain a performance improvement.
<li>More aggressive optimization of the AND operator when one side or the
    other is always false.
<li>Improved performance of queries with many OR-connected terms in the
    WHERE clause that can all be indexed.
<li>Add the [SQLITE_RTREE_INT_ONLY] compile-time option to force the
    [rtree | R*Tree Extension Module] to use integer instead of
    floating point values for both storage and computation.
<li>Enhance the [PRAGMA integrity_check] command to use much less memory when
    processing multi-gigabyte databases.
<li>New interfaces added to the test_quota.c add-on module.
<li>Added the ".trace" dot-command to the command-line shell.