Lucene LIMITBY

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

koenv

Hello,

I'm trying to limit a lucene search but still got more results then asked.

s.setLanguage(SearchService.LANGUAGE_LUCENE);
s.setLimitBy(LimitBy.FINAL_SIZE);
s.setLimit(1000);
s.setQuery(query);
s.addStore(storeRef);

Still having results with thousands of records.
If i try to read only the first 1000 records of the big result, it is very slow!

I am running this as System User … on Alfresco Enterprise 2.2

Anyone idea what is the problem?

thanks,
Koen

koenv

More concrete update of description above:

I'm trying to limit lucene search results with following code:

a)   
SearchParameters s = new ..

s.setLanguage(SearchService.LANGUAGE_LUCENE);
s.setLimitBy(LimitBy.FINAL_SIZE);
s.setLimit(1000);
s.setQuery(query);
s.addStore(storeRef);


You can read on http://wiki.alfresco.com/wiki/Search:
“The maximum size of the result set can be set. The return results set will be no bigger than this size.”

I still get a result set with thousands of records.


b)If I try to read only the first 1000 records of the big result (700000hits), it is very slow! (>5 seconds)
This only happens when a PATH is specified in the query.

int i=0;
for (ResultSetRow row : results)
{
NodeRef currentNodeRef = row.getNodeRef(); nodeList.add(currentNodeRef);
      i++;
if (i > 1000) break;
}

Example:

“+TYPE:"cm:content" +@cm\:name:"*1234*"  +PATH:"/app:company_home/cm:test//*"

runs much slower than the same query without a path.

“+TYPE:"cm:content" +@cm\:name:"*1234*"  " ”



Note: I am running this as System User … on Alfresco Enterprise 2.2