Project

General

Profile

« Previous | Next » 

Revision 4832

Added by daigle about 15 years ago

Added jing's suggested changes

View differences:

docs/dev/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