Lucene issue over 1000 results

[g_rathod]

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 result but after full indexing and restarting alfresco it solve problem.
e.g. PATH:"/app:company_home/cm:My_x0020_Space/cm:Asset_x0020_Hierarchy//*" AND @mypro\:assetabc:1032136
where  PATH:"/app:company_home/cm:My_x0020_Space/cm:Asset_x0020_Hierarchy//*"  contains 1500 result. but I can't find data "1032136".
but giving AND condition gives me result.

What could be the problem and resolution??

[mitpatoliya]

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.

[g_rathod]

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?

[mitpatoliya]

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.

[g_rathod]

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.