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

[Dmitriy S. <sha...@gm...>]

On Fri, 2010-07-09 at 15:17 +0200, Patrick Schäfer wrote:
> 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
> 09 Jul 2010 15:11:58,119 [P1-9] TRACE (Optimize.java [before]:240) - 
> exist:optimize: context step: 
> descendant-or-self::xq:molecule[attribute::id = "298038"]
> 09 Jul 2010 15:11:58,119 [P1-9] TRACE (Optimize.java [before]:241) - 
> exist:optimize: context var: null
> 09 Jul 2010 15:11:59,496 [P1-9] TRACE (GeneralComparison.java 
> [preSelect]:266) - Using QName index on type xs:string
> 09 Jul 2010 15:11:59,496 [P1-9] TRACE (GeneralComparison.java 
> [preSelect]:298) - Using QName range index for key: 298038
> 09 Jul 2010 15:11:59,666 [P1-9] TRACE (Optimize.java [eval]:120) - 
> exist:optimize: pre-selection: 1
> ...
> 9 Jul 2010 15:11:59,837 [P1-9] DEBUG (XQuery.java [execute]:231) - 
> Execution took 4.050 ms

If calculate execution time throw log, get 58,119 - 58,119 = 1.547 ms
for collection("tuscreen")//xq:molecule[@id="298038"] Yes, it's slow,
but the rest should be much faster ... strange ...

What version do you use?

-- 
Cheers,

Dmitriy Shabanov