custom Oak Index took longer time to re-index | Community
Skip to main content
New Participant
May 24, 2016
Solved

custom Oak Index took longer time to re-index

  • May 24, 2016
  • 3 replies
  • 1390 views

Hi Team,

 

I have been trying to run multipath query through query builder but it takes more time to result a query (approx 40Sec).

 

daterange.upperOperation=<=

daterange.upperBound=2016-05-24T12:00:06.182-04:00

daterange.property=jcr:content/offTime

1_property=jcr:content/cq:lastReplicationAction

group.1_path=/content/mywebsite

p.limit=200

1_property.value=Activate

group.2_path=/etc/mywebsite/en-us

type=cq:Page

group.p.or=true

 

To overcome such situation I created custom oakIndex where include both the paths to process the above query. But the problem is when I enable the reIndex property to true then it took longer time to complete indexing and never ends on my local instance. 

 

Please let me know how long will reIndexing takes to re-index. Also let me know is there any other way to tune the query. 

 

Thank you

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 ogill

Hi,

tail the error.log file, you will see when the re-index starts and when it finishes, see below

26.05.2016 13:33:51.780 *INFO* [pool-7-thread-2] org.apache.jackrabbit.oak.plugins.index.IndexUpdate Reindexing will be performed for following indexes: [/oak:index/cqPageLucene]

26.05.2016 13:33:54.610 *INFO* [pool-7-thread-2] org.apache.jackrabbit.oak.plugins.index.AsyncIndexUpdate Reindexing (async) completed for indexes: [/oak:index/cqPageLucene*(1622)] in 2.839 s

To re-index and  manage your indexes I recommend installing the ACS Commons Indexing Tools[0]

Regards,

Opkar

[0]https://docs.adobe.com/docs/en/aem/6-0/deploy/upgrade/queries-and-indexing.html#ACS%20Commons%20Indexing%20Tools

3 replies

ogillAccepted solution
Employee
May 26, 2016

Hi,

tail the error.log file, you will see when the re-index starts and when it finishes, see below

26.05.2016 13:33:51.780 *INFO* [pool-7-thread-2] org.apache.jackrabbit.oak.plugins.index.IndexUpdate Reindexing will be performed for following indexes: [/oak:index/cqPageLucene]

26.05.2016 13:33:54.610 *INFO* [pool-7-thread-2] org.apache.jackrabbit.oak.plugins.index.AsyncIndexUpdate Reindexing (async) completed for indexes: [/oak:index/cqPageLucene*(1622)] in 2.839 s

To re-index and  manage your indexes I recommend installing the ACS Commons Indexing Tools[0]

Regards,

Opkar

[0]https://docs.adobe.com/docs/en/aem/6-0/deploy/upgrade/queries-and-indexing.html#ACS%20Commons%20Indexing%20Tools

New Participant
May 26, 2016

Hi ,

 

Thank you for a quick response . 

I still need to know how can I monitor the time taken to re-index new oakIndex.

Thank you

Sumit singhal

smacdonald2008
New Participant
May 24, 2016

Oak indexing is the method you use to tone queries. 

The only advice i have for this question is to watch GEMs session on OAK indexing. they cover this type of question: 

http://dev.day.com/content/ddc/en/gems/oak-lucene-indexes.html

Hope this helps.. .