topic Re: Lucene issue over 1000 results in Alfresco Archive

Lucene issue over 1000 results

g_rathod — Tue, 20 Nov 2012 10:23:02 GMT

Hi Friends,I am facing inconsistency while querying.e.g. Lets I have 1500 rows of result. I am querying to find some "abc.txt". Lucene will display first 1000 results which will not include abc.txt. but next 500 result will contains abc.txt.So would it affect my query? as I am sometime not getting

Re: Lucene issue over 1000 results

mitpatoliya — Tue, 20 Nov 2012 10:47:44 GMT

The problem is related to the limitation of resultset of lucene.
There are few properties in the alfresco-global.properties file realted to lucene resultset size.
by default it is set to 1000 so if you increase that value you will be able to get more results in first query fire itself.
I hope it solve your problem.

Re: Lucene issue over 1000 results

g_rathod — Tue, 20 Nov 2012 11:18:14 GMT

Thanks Mittal ,

Actually I dont want modify that property. But what I concern more is inconsistent result.
Sometimes it will display and sometimes not. Do we require to full reindex everytime when problem happens?

Re: Lucene issue over 1000 results

mitpatoliya — Tue, 20 Nov 2012 11:31:47 GMT

See the problem is again as I said with the limitation of lucene only as with the limitation it fetches result in the batches so if there are more then thousand documents in your result set it could be included in the first batch or second no guarantee.
If you want to have specific resultset better use AND query to filter out the results.

Re: Lucene issue over 1000 results

g_rathod — Tue, 20 Nov 2012 11:45:16 GMT

Mittal,

I used AND query.. as mentioned.

PATH:"/app:company_home/cm:My_x0020_Space/cm:Asset_x0020_Hierarchy//*" AND @mypro\:assetabc:1032136

still sometime result is not coming up… so I go upper level first and anlayse criteria. It should come.