Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Fix typo on the famous.html page. Other updates prior to publication. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
5572b2965de2e6d5f0323d78cf9e1fb7 |
| User & Date: | drh 2009-11-30 13:55:14 |
|
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 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:
|