Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix an obsolete example in the FTS3 documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c90c7a10154222aa731d84a01f15ae49 |
| User & Date: | drh 2017-01-29 11:39:33 |
Context
|
2017-02-02
| ||
| 14:48 | Update the wording on the description of the WHEN clause on triggers. check-in: 09d3dc5c51 user: drh tags: trunk | |
|
2017-01-29
| ||
| 11:39 | Fix an obsolete example in the FTS3 documentation. check-in: c90c7a1015 user: drh tags: trunk | |
|
2017-01-28
| ||
| 14:45 | Updates to the performance graph spreadsheet. check-in: 63d1835d75 user: drh tags: trunk | |
Changes
Changes to pages/fts3.in.
306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 |
<codeblock>
<i>-- The examples in this block assume the following FTS table:</i>
CREATE VIRTUAL TABLE mail USING fts3(subject, body);
SELECT * FROM mail WHERE rowid = 15; <i>-- Fast. Rowid lookup.</i>
SELECT * FROM mail WHERE body MATCH 'sqlite'; <i>-- Fast. Full-text query.</i>
SELECT * FROM mail WHERE mail MATCH 'search'; <i>-- Fast. Full-text query.</i>
SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20; <i>-- Slow. Linear scan.</i>
SELECT * FROM mail WHERE subject = 'database'; <i>-- Slow. Linear scan.</i>
SELECT * FROM mail WHERE subject MATCH 'database'; <i>-- Fast. Full-text query.</i>
</codeblock>
<p>
In all of the full-text queries above, the right-hand operand of the MATCH
operator is a string consisting of a single term. In this case, the MATCH
|
| |
306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 |
<codeblock>
<i>-- The examples in this block assume the following FTS table:</i>
CREATE VIRTUAL TABLE mail USING fts3(subject, body);
SELECT * FROM mail WHERE rowid = 15; <i>-- Fast. Rowid lookup.</i>
SELECT * FROM mail WHERE body MATCH 'sqlite'; <i>-- Fast. Full-text query.</i>
SELECT * FROM mail WHERE mail MATCH 'search'; <i>-- Fast. Full-text query.</i>
SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20; <i>-- Fast. Rowid lookup.</i>
SELECT * FROM mail WHERE subject = 'database'; <i>-- Slow. Linear scan.</i>
SELECT * FROM mail WHERE subject MATCH 'database'; <i>-- Fast. Full-text query.</i>
</codeblock>
<p>
In all of the full-text queries above, the right-hand operand of the MATCH
operator is a string consisting of a single term. In this case, the MATCH
|