Documentation Source Text

Check-in [5572b2965d]
Login

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

Overview
Comment:Fix typo on the famous.html page. Other updates prior to publication.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5572b2965de2e6d5f0323d78cf9e1fb756b060cb
User & Date: drh 2009-11-30 13:55:14.000
Context
2009-11-30
15:27
Update indicative performance numbers for populating a large database in fts3.html. (check-in: 54090fd49f user: dan tags: trunk)
13:55
Fix typo on the famous.html page. Other updates prior to publication. (check-in: 5572b2965d user: drh tags: trunk)
11:52
Fix some problems with fts3.html. (check-in: 0b949f6763 user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2009 Dec 05 (3.6.21)} {
<li>The SQL output resulting from [sqlite3_trace()] is now modified to include
the values of [parameters | bound parameters].
<li>Performance optimizations targetting a specific use case from
a single high-profile user of SQLite.  A 12% reduction in the number of
CPU operations is achieved (as measured by valgrind).  Actual performance
improvements in practice may vary depending on workload.  Changes
include:
<ul>
<li>The [ifnull()] and [coalesce()] SQL functions are now implemented







|







40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2009 Dec 05 (3.6.21)} {
<li>The SQL output resulting from [sqlite3_trace()] is now modified to include
the values of [bound parameters].
<li>Performance optimizations targetting a specific use case from
a single high-profile user of SQLite.  A 12% reduction in the number of
CPU operations is achieved (as measured by valgrind).  Actual performance
improvements in practice may vary depending on workload.  Changes
include:
<ul>
<li>The [ifnull()] and [coalesce()] SQL functions are now implemented
Changes to pages/famous.in.
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86

<tr><td valign="top">
<a href="http://www.ge.com/">
<img src="images/foreignlogos/ge.gif" border="0"></a>
</td><td>
We believe that [http://www.ge.com/ | General Electric]
uses SQLite in some product or 
another because they twice wrote the to SQLite developers requesting 
the US Export Control Number for SQLite. So presumably GE is using
SQLite in something that they are exporting. But nobody
(outside of GE) seems to know what that might be.
</td>


<tr><td valign="top">







|







72
73
74
75
76
77
78
79
80
81
82
83
84
85
86

<tr><td valign="top">
<a href="http://www.ge.com/">
<img src="images/foreignlogos/ge.gif" border="0"></a>
</td><td>
We believe that [http://www.ge.com/ | General Electric]
uses SQLite in some product or 
another because they twice wrote to the SQLite developers requesting 
the US Export Control Number for SQLite. So presumably GE is using
SQLite in something that they are exporting. But nobody
(outside of GE) seems to know what that might be.
</td>


<tr><td valign="top">
Changes to pages/lang.in.
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
X'53514C697465'
</pre></blockquote>

<p>
A literal value can also be the token "NULL".
</p>

<tcl>hd_fragment varparam parameter parameters {bound parameter}</tcl>
<h3>Parameters</h3>
<p>
A "variable" or "parameter" token
specifies a placeholder in the expression for a literal
value that is filled in at runtime using the
[sqlite3_bind_blob() | sqlite3_bind()] family of C/C++ interfaces.
Parameters can take several forms:







|







1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
X'53514C697465'
</pre></blockquote>

<p>
A literal value can also be the token "NULL".
</p>

<tcl>hd_fragment varparam parameter parameters {bound parameter} {bound parameters}</tcl>
<h3>Parameters</h3>
<p>
A "variable" or "parameter" token
specifies a placeholder in the expression for a literal
value that is filled in at runtime using the
[sqlite3_bind_blob() | sqlite3_bind()] family of C/C++ interfaces.
Parameters can take several forms: