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/[EMAIL PROTECTED]:uuid='a2e5266f-9f2f-4683-993f-b73f34ba94a7' or @jcr:uuid='5fbc094f-e6c6-48b3-9083-49fe18a27c4a']//element(*,nt:unstructured)[EMAIL PROTECTED]'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/[EMAIL PROTECTED]: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.
