custom Oak Index took longer time to re-index | Adobe Higher Education
Skip to main content
Level 4
May 24, 2016
Beantwortet

custom Oak Index took longer time to re-index

  • May 24, 2016
  • 3 Antworten
  • 1392 Ansichten

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

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von 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 Antworten

smacdonald2008
Level 10
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.. . 

Level 4
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

ogillAdobe EmployeeAntwort
Adobe 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