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: > //[EMAIL PROTECTED]: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. > >
