Revision 4832
Added by daigle almost 16 years ago
query-caching.html | ||
---|---|---|
61 | 61 |
<div class="toc1"><a href="#PathIndexing">Common XML Path Indexing</a></div> |
62 | 62 |
<div class="toc2"><a href="#HowPathIndexingWorks">How Common Path Indexing Works</a></div> |
63 | 63 |
<div class="toc2"><a href="#PathIndexingDrawbacks">Common Path Indexing Drawbacks</a></div> |
64 |
<div class="toc1"><a href="#UniqueResultset">Storing Unique Storing Unique Return Fields</a></div> |
|
65 |
<div class="toc2"><a href="#HowUniqueResultsetWorks">How Storing Unique Storing Unique Return Fields Works</a></div> |
|
64 |
<div class="toc1"><a href="#UniqueResultset">Storing Unique Return Fields</a></div> |
|
65 |
<div class="toc2"><a href="#HowUniqueResultsetWorks">How Storing Unique Return Fields Works</a></div> |
|
66 |
<div class="toc2"><a href="#UniqueResultsetDrawbacks">Drawbacks to Storing Unique Return Fields</a></div> |
|
66 | 67 |
</div> |
67 | 68 |
|
68 | 69 |
<a name="Overview"></a><div class="header1">Overview</div> |
... | ... | |
156 | 157 |
query result.</p> |
157 | 158 |
|
158 | 159 |
<p>If the desired docid and result fields are found in these two tables, the query results are returned |
159 |
directly from the xml_queryresult table and the xml_nodes table is never touched.</p>
|
|
160 |
directly from the xml_queryresult table and the xml_indes and xml_nodes tables are never touched.</p>
|
|
160 | 161 |
|
161 |
<p>Overall, this strategy works well.</p> |
|
162 |
|
|
162 |
<a name="UniqueResultsetDrawbacks"></a><div class="header2">Drawbacks to Storing Unique Return Fields</div> |
|
163 |
<p>The main issue with storing unique query results is that the query must be performed at least once for |
|
164 |
each unique set of results and docid before it is added to the xml_returnfield and xml_queryresult tables. |
|
165 |
This first run goes against the xml_index and xml_nodes tables and is slow.</p> |
|
163 | 166 |
<br> |
164 | 167 |
<!-- a href="add back file here when one exists" -->Back<!-- /a --> | <a href="./index.html">Home</a> | |
165 | 168 |
<a href="./service-base.html">Next</a> |
Also available in: Unified diff
Added jing's suggested changes