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

[Wolfgang M. <wol...@ex...>]

> 09 Jul 2010 15:11:55,784 [P1-9] DEBUG (XQuery.java [compile]:161) -
> Compilation took 4 ms
> 09 Jul 2010 15:11:58,119 [P1-9] TRACE (Optimize.java
> [visitGeneralComparison]:219) - exist:optimize: found optimizable:
> org.exist.xquery.GeneralComparison

Most of the time seems to be spent after the query was compiled and
before query execution starts. I would thus suspect that loading the
metadata of your documents is the bottleneck, not the actual query.
How long does it take to execute collection("tuscreen") on its own?

The document loading should only have a negative effect the first time
the query is executed. Subsequent queries will use the cached set.

You may also check if increasing the collectionCache setting in
conf.xml does help.

Wolfgang