Re: [Exist-development] query collection containing one million documents

[Joe W. <jo...@gm...>]

Hi Patrick,

What are your memory settings?  Seeing this sometimes helps folks on
the list troubleshoot.  -Xmx, -Xms, and the "cacheSize" and
"collectionCache" and other attributes of the <db-connection> element
in your conf.xml file.

This might take you on the wrong track, but you could try adding a
Lucene index on @id / @value.  Even though we usually think of using
Lucene for fulltext search, it might be worth trying out the
whitespace analyzer -- see http://exist-db.org/lucene.html#N102F8.
Given all of the weird characters in your @value example, you should
probably construct your query as XML rather than using the lucene
search query parser, which could get thrown off -- see
http://exist-db.org/lucene.html#N10352.  It'd be interesting to know
how this works compared to the range indexes.

Joe