jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gongtao <gongtao...@yahoo.cn>
Subject search speed
Date Tue, 22 Jul 2008 06:17:35 GMT

there are 300,000 records in the repository. 

Why the increase as the result set, for speed will slow ? I set up to offset
15   limit 100

Statements:
//nko:workspace/*[@jcr:uuid='a2e5266f-9f2f-4683-993f-b73f34ba94a7' or
@jcr:uuid='5fbc094f-e6c6-48b3-9083-49fe18a27c4a']//element(*,nt:unstructured)[@templateName='4137345d-3acd-4fc6-befe-6367a3c8f842'
and @stateCode=1  and  @directory=false()] order by @name ascending

results:30,000  time:5703ms
results:300,000  time:30406ms



Full Text Search more slowly
Statements:
/jcr:root/nko:root/nko:workspace/*[@jcr:uuid='a2e5266f-9f2f-4683-993f-b73f34ba94a7'
or
@jcr:uuid='5fbc094f-e6c6-48b3-9083-49fe18a27c4a']//element(*,nt:base)[jcr:contains(.,'superman
OR *superman*') and  @stateCode=1 and @directory=false()] order by
@lastModified ascending

results:30,000 time:14360ms
-- 
View this message in context: http://www.nabble.com/search-speed-tp18583171p18583171.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.


Mime
View raw message