[Upgarde] [Search] Fulltext Search taking around 50 minutes to complete | Community
Skip to main content
A
Anonymous
November 3, 2015
Solved

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

  • November 3, 2015
  • 4 replies
  • 803 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by kautuk_sahni

    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

    4 replies

    smacdonald2008
    smacdonald2008
    Level 10
    November 3, 2015

    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
    Community Manager
    kautuk_sahniCommunity ManagerAccepted solution
    Community Manager
    November 3, 2015

    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
      Sham_HC
      Sham_HC
      Level 10
      November 9, 2015

      Follow [1] & attach all the logs.

       

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

      Lokesh_Shivalingaiah
      Lokesh_Shivalingaiah
      Level 10
      November 9, 2015

      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

      Terms & ConditionsAccessibility statement

      Loading footer...