Hi<div>I have a bigger collection</div><div><br></div><div>DDR-All</div><div><div>Database Properties</div><div> Name: DDR-All</div><div> Size: 743 MB</div><div> Nodes: 33340760</div><div> Height: 8</div><div><br></div><div>
Database Creation</div><div> Source Path: D:/var/TICEReports/JSDI data/bezne</div><div> Time Stamp: 26.10.2010 02:08:30</div><div> Input Size: 542 MB</div><div> Encoding: utf-8</div><div> Documents: 79313</div><div> Whitespace Chopping: ON</div>
<div> Entity Parsing: OFF</div><div><br></div><div>Indexes</div><div> Path Summary: ON</div><div> Text Index: ON</div><div> Attribute Index: ON</div><div> Full-Text Index: OFF</div><div><br></div>When I run xquery count(//MSG)</div>
<div>it shows result 511990, which is correct.</div><div>However, it takes a lot of time to produce that result. I thought, that with existing indices it shall bring the result in seconds, and not in minutes (like 10 minutes)</div>
<div>Note, that I have created the collection before 6.3 was released, so this might be the case and I would have to import it all again.</div><div><br></div><div>I was trying to run xquery, using indices</div><div><span class="Apple-style-span" style="font-family: &#39;Andale Mono&#39;, monospace; font-size: 13px; line-height: 18px; white-space: pre; ">xquery basex:index(&#39;MSG&#39;, &#39;path&#39;)</span></div>
<div><div style="font-family: arial; line-height: normal; white-space: normal; "><span class="Apple-style-span" style="font-family: &#39;Andale Mono&#39;, monospace; font-size: 13px; line-height: 18px; white-space: pre; ">xquery basex:index(&#39;//MSG&#39;, &#39;path&#39;)</span></div>
but I got a feeling, I do not got it properly, as it responds</div><div>&quot;Unknown index path&quot;</div><div><br></div><div>What I would like to know is</div><div><ul><li>names of indices available</li><li>what is basex:index function usable for and for what it is not</li>
<li>can I create my own indices? Like calculating date from dateTime fileds in XML. I guess it is not supported.</li><li>any further reading? Most of the description is related to full text, but this is not my case.</li></ul>
<div>Jan</div></div><div><br></div><div>PS: Despite of some performance problems (query lasting 25 minutes) I was able to dig out some very valuable information, which would be inefficient and probably much more error prone in any other way.</div>
<div><a href="http://janvlcinsky.s3.amazonaws.com/projects/Monitor/websamples/timeplot/tgen-count.html">http://janvlcinsky.s3.amazonaws.com/projects/Monitor/websamples/timeplot/tgen-count.html</a></div><div>-- <br><div name="sig_b0a60a250d" style="margin-top:2em;margin-right:0pt;margin-bottom:2em;margin-left:0pt">
<b>Jan Vlčinský</b><br><small>
Slunečnicová 338/3, 734 01 Karviná Ráj, Czech Republic<br>
tel: +420-597 602 024;
mob: +420-608 979 040<br>
skype: janvlcinsky;
GoogleTalk: <a href="mailto:jan.vlcinsky@gmail.com" target="_blank">jan.vlcinsky@gmail.com</a></small></div><br>
</div>