topic Re: Lucene query problem in Alfresco Archive

Lucene query problem

beslan — Tue, 12 Feb 2013 08:18:00 GMT

Hi, I am using SDK 4.2.b and java api. When I call a lucene query like below, it takes 5 minutes and there are only 4 contents.In alfresco.log I saw lines about lucene index cleaner.I added log file.Any suggestions. SearchParameters searchParameters = new SearchParameters(); searchParamete

Re: Lucene query problem

abarisone — Tue, 12 Feb 2013 08:27:29 GMT

Hi,
you may force to rebuild index and take a look to how much memory you gave to Alfresco for startup…
Could you provide an extract from Alfresco.log?

Regards,
Andrea

Re: Lucene query problem

beslan — Tue, 12 Feb 2013 09:26:35 GMT

Hi,

I did a full reindex.

JVM memory parameters are MaxPermSize=512m -Xms256M -Xmx3500M

I added alfresco.log. <a>https://forums.alfresco.com/sites/forums/files/alfresco_2.txt</a>

Thanks.

Re: Lucene query problem

mitpatoliya — Tue, 12 Feb 2013 09:29:23 GMT

why are you doing this?
searchParameters.setMaxPermissionCheckTimeMillis(30000);
searchParameters.setMaxPermissionChecks(100000);

This is not required unless you have very large resultset.
Also could you post your query?

Re: Lucene query problem

beslan — Tue, 12 Feb 2013 10:13:50 GMT

Yes I have very large resultset. But I will limit the resultset to 500;


+PATH:"/app:company_home/cm:archive//*" AND  @\{http\://www.uz.com/metadata\}contentModel:'8295ae0a-8e1d-4a90-ba37-20fff0b4c1a3" AND  @\{http\://www.uz.com/metadata\}Ada:'5115" AND  @\{http\://www.uz.com/metadata\}Parsel:'1"
‍‍‍

Thanks,
Beslan

Re: Lucene query problem

jpfi — Tue, 12 Feb 2013 10:56:02 GMT

Hi,
PATH queries with "//*" are very slow if you use LUCENE search subsystem.
You should try to avoid such PATH entries if possible.
Cheers, Jan

Re: Lucene query problem

mitpatoliya — Tue, 12 Feb 2013 11:41:20 GMT

Yes, make it more targeted
also one more thing are you using any clustering?
Also if any one of the space huge number of documents it is advisable to categories them and distribute them among the subfolders.

Re: Lucene query problem

beslan — Sat, 16 Feb 2013 04:39:27 GMT

Hi,

Removing PATH is the key. Everything is fine now.

Thanks,
Beslan

Re: Lucene query problem

andy — Wed, 20 Feb 2013 15:02:45 GMT

Hi

Are you using SOLR or the lucene search subsystem.
SOLR is much faster at this sort of PATH query.

Andy