Re: [Exist-open] Unable to exploit Indexes on large collections

[Marco L. <m.l...@we...>]

Pierrick,
I've read the document you're pointing us to (actually that's where 
we've got the indexing theory from).
I'll try to augment the log level to see if there's some hidden caveat ...

Anyway here's an example query we try to execute:

xquery version "1.0";

declare namespace [...]

declare function query:allObservationsFrom($fromStr as xs:string)
  as element()*
{
let $fromDate := xs:dateTime($fromStr)
for $obs in 
/om:RichObservation[gml:timeStamp/gml:TimeInstant/xs:dateTime(gml:timePosition) 
 >= $fromDate]
return $obs
};




Pierrick Brihaye wrote:

> Mauro Mugnaini a écrit :
>
>> Now, I have to perform queries
>
>
> What kind of queries ?


> <collection xmlns="http://exist-db.org/collection-config/1.0">
>    <index [... nsdecl ...]>;
>        <fulltext default="none" attributes="true" alphanum="true">;
>            <include path="/om:RichObservation/om:using/@xlin:href"/>;
>            <include 
> path="/om:RichObservation/om:observable/@xlin:href"/>;
>        </fulltext>
>        <create
> path="/om:RichObservation/gml:timeStamp/gml:TimeInstant/gml:timePosition"
> type="xs:dateTime"/>
>    </index>
> </collection>

>
> Looks OK.
>
>> I would like to know if there's something I'm doing wrong (indexer depth
>> in server configuration?
>
>
> Did you have a look at 
> http://exist.sourceforge.net/indexing.html#N10530 ?
>
> Cheers,
>