jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ard Schrijvers" <a.schrijv...@onehippo.com>
Subject RE: the multi-user synchronization queries
Date Tue, 29 Jul 2008 09:44:02 GMT
Hello gongtao,

You should limit the number of results by using setLimit and setOffset.
Then I am sure the query below will execute in several ms.

-Ard

> 
> How to improve the speed,when the multi-user synchronization queries ?
> there are 1,000,000 records in the repository.
> statement:
> //*[@jcr:uuid='a2e5266f-9f2f-4683-993f-b73f34ba94a7' or
> @jcr:uuid='5fbc094f-e6c6-48b3-9083-49fe18a27c4a']//element(*,n
> t:unstructured)[jcr:contains(.,'wuhan')
> and  @stateCode=1 and @directory=false()] order by @name ascending
> 
> user number       time(ms)      result number
>      1                  7858              70000
>      10                26408             70000
>      100              133286            70000
> --
> View this message in context: 
> http://www.nabble.com/the-multi-user-synchronization-queries-t
> p18704162p18704162.html
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
> 
> 

Mime
View raw message