[Upgarde] [Search] Fulltext Search taking around 50 minutes to complete

[Former Community Member]

Hi,

We have upgraded from from version 5.6.1 to 6.1, and the fulltext search on website which used to take around 10-15 secs to complete, now has started taking around 50 minutes to complete. I have re-indexed all the oak:indexes , created a new lucene index with just the binaries and title and description properties, the time taken has improved to around 2.5 minutes to 3 minutes. But it is still way too much and I do not have any pointers to proceed/debug further.

Any help/pointers will be much appreciated.

Thanks in advance.

[smacdonald2008]

From what you describe - it looks like the issue is with the OAK index:

https://jackrabbit.apache.org/oak/docs/query/lucene.html

Take a look at this KB - it has some information on OAK index performance tips:

https://helpx.adobe.com/experience-manager/kb/performance-tuning-tips.html

[kautuk_sahni · Accepted solution]

Hi

Please have a look at following reference article, that could act as some help to you:

Lnk:- https://docs.adobe.com/docs/en/aem/6-1/deploy/platform/queries-and-indexing.html

Link:- http://tech.ethomasjoseph.com/2015/03/tuning-your-jcr-queries-for-aem.html

Link:- http://www.wemblog.com/2012/01/how-to-reduce-lucene-index-size-in-cq.html

//How to reduce Lucene Index size in CQ / WEM

I hope this would help you.

Thanks and Regards

Kautuk Sahni

[Sham_HC]

Follow [1] & attach all the logs.

[1]  https://docs.adobe.com/docs/en/aem/6-1/deploy/platform/queries-and-indexing.html#Troubleshooting%20i...

[Lokesh_Shivalingaiah]

http://<host>:<port>/libs/granite/operations/content/diagnosis/tool.html/_granite_queryperformance

Click on 'Explain Query'. Add your query here and see the explanation. You also attach the same here