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

[Patrick S. <pat...@zi...>]

  Hi Dmitriy,

I get similar results for every repetition of the query:
12 Jul 2010 11:13:02,503 [P1-9] DEBUG (XQuery.java [execute]:231) - 
Execution took 3.780 ms
12 Jul 2010 11:13:02,504 [P1-9] DEBUG (HTTPUtils.java 
[addLastModifiedHeader]:61) - mostRecentDocumentTime: 0
12 Jul 2010 11:13:02,504 [P1-9] DEBUG (HTTPUtils.java 
[addLastModifiedHeader]:61) - mostRecentDocumentTime: 0
12 Jul 2010 11:13:02,504 [P1-9] INFO  (RpcConnection.java [doQuery]:303) 
- query took 3781ms.
12 Jul 2010 11:13:02,504 [P1-9] DEBUG (RpcConnection.java [queryP]:2434) 
- found 1


12 Jul 2010 11:13:43,418 [P1-9] DEBUG (XQuery.java [execute]:231) - 
Execution took 3.779 ms
12 Jul 2010 11:13:43,418 [P1-9] DEBUG (HTTPUtils.java 
[addLastModifiedHeader]:61) - mostRecentDocumentTime: 0
12 Jul 2010 11:13:43,418 [P1-9] DEBUG (HTTPUtils.java 
[addLastModifiedHeader]:61) - mostRecentDocumentTime: 0
12 Jul 2010 11:13:43,418 [P1-9] INFO  (RpcConnection.java [doQuery]:303) 
- query took 3779ms.

12 Jul 2010 11:13:59,979 [P1-9] DEBUG (XQuery.java [execute]:231) - 
Execution took 3.908 ms
12 Jul 2010 11:13:59,979 [P1-9] DEBUG (HTTPUtils.java 
[addLastModifiedHeader]:61) - mostRecentDocumentTime: 0
12 Jul 2010 11:13:59,980 [P1-9] DEBUG (HTTPUtils.java 
[addLastModifiedHeader]:61) - mostRecentDocumentTime: 0
12 Jul 2010 11:13:59,980 [P1-9] INFO  (RpcConnection.java [doQuery]:303) 
- query took 3909ms.
12 Jul 2010 11:13:59,980 [P1-9] DEBUG (RpcConnection.java [queryP]:2434) 
- found 1


Patrick



> On Fri, 2010-07-09 at 16:54 +0200, Patrick Schäfer wrote:
>> 09 Jul 2010 16:52:50,788 [P1-9] TRACE (Optimize.java [eval]:160) -
>> exist:optimize: inner expr took 91; found: 1
>> 09 Jul 2010 16:52:50,789 [P1-9] DEBUG (XQuery.java [execute]:231) -
>> Execution took 3.710 ms
> Is it first request, do you have same value for next one?
>
> As you can see the selection is quite fast. The problem is some where
> else, IMHO.
>