Expand my Community achievements bar.

SOLVED

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

Avatar

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.

1 Accepted Solution

Avatar

Correct answer by
Administrator

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



Kautuk Sahni

View solution in original post

4 Replies

Avatar

Level 10

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

Avatar

Correct answer by
Administrator

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



Kautuk Sahni

Avatar

Level 10

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