custom Oak Index took longer time to re-index

[_SumitSinghal]

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

[smacdonald2008]

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.. . 

[_SumitSinghal]

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

[Opkar_Gill · Accepted solution]

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%20Inde...