Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Anonymous
Not applicable

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
kautuk_sahni
Correct answer by
Employee
Employee

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

View solution in original post

4 Replies
smacdonald2008
Level 10
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

kautuk_sahni
Correct answer by
Employee
Employee

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

Lokesh_Shivalingaiah
Community Advisor
Community Advisor

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