Indexing for XS:dateTime @jcr:created .

[Gokul2011]

Hi All,

I am continuously getting the below WARN , tried several ways to optimized but  i am  not getting to update proper property type oak:index  for this below

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

04.10.2015 22:29:39.655 *WARN*[1443977978964] GET /bin/querybuilder.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 44000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:created] >= cast('2015-10-04T00:00:00.000+05:30' as date) and isdescendantnode(a, '/content/dam/core-assets/photo-upload') /* xpath: /jcr:root/content/dam/core-assets/photo-upload//*[(@jcr:created >= xs:dateTime('2015-10-04T00:00:00.000+05:30'))] */, path=/content/dam/core-assets/photo-upload//*, property=[jcr:created=[[2015-10-04T00:00:00.000+05:30..]]); consider creating an index or changing the query
04.10.2015 22:29:39.671 *WARN* [1443977978964] GET /bin/querybuilder.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 45000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:created] >= cast('2015-10-04T00:00:00.000+05:30' as date) and isdescendantnode(a, '/content/dam/core-assets/photo-upload') /* xpath: /jcr:root/content/dam/core-assets/photo-upload//*[(@jcr:created >= xs:dateTime('2015-10-04T00:00:00.000+05:30'))] */, path=/content/dam/core-assets/photo-upload//*, property=[jcr:created=[[2015-10-04T00:00:00.000+05:30..]]); consider creating an index or changing the query
04.10.2015 22:29:39.687 *WARN* [1443977978964] GET /bin/querybuilder.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 46000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:created] >= cast('2015-10-04T00:00:00.000+05:30' as date) and isdescendantnode(a, '/content/dam/core-assets/photo-upload') /* xpath: /jcr:root/content/dam/core-assets/photo-upload//*[(@jcr:created >= xs:dateTime('2015-10-04T00:00:00.000+05:30'))] */, path=/content/dam/core-assets/photo-upload//*, property=[jcr:created=[[2015-10-04T00:00:00.000+05:30..]]); consider creating an index or changing the query
04.10.2015 22:29:39.703 *WARN*  [1443977978964] GET /bin/querybuilder.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 47000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:created] >= cast('2015-10-04T00:00:00.000+05:30' as date) and isdescendantnode(a, '/content/dam/core-assets/photo-upload') /* xpath: /jcr:root/content/dam/core-assets/photo-upload//*[(@jcr:created >= xs:dateTime('2015-10-04T00:00:00.000+05:30'))] */, path=/content/dam/core-assets/photo-upload//*, property=[jcr:created=[[2015-10-04T00:00:00.000+05:30..]]); consider creating an index or changing the query

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Due to this reason , we are facing slow perfromance, Please provide an  suitable package for this query.

[Gokul2011]

Please provide oak:index  as package

[smacdonald2008]

To improve performance here - you create an OAK index - this is an AEM configuration. See the official AEM docs for more information:

https://docs.adobe.com/docs/en/aem/6-0/deploy/upgrade/queries-and-indexing.html

Also - read the OAK docs on OAK indexing:

https://jackrabbit.apache.org/oak/docs/query/lucene.html

[Gokul2011]

while creating index through docs  , i am getting error oakconstraint error during node save on CRXDE.

If anyone have already created a package of this index.please share .

[Gokul2011]

Hi Opkar.

Thanks for reply

yes i tried creating  index following docs provided by smac.

Could you please help which node and property do i need to index?

[Opkar_Gill]

Hi,

when you say "creating index through docs", do you mean "creating the index following the docs"?

When creating an index in AEM, you need to create the properties as well before you attempt to save the index, otherwise you will get an error on saving.

Regards,

Opkar

[Opkar_Gill]

Hi Pradeep,

did you create the index and resolve the issue?

Regards,

Opkar 

[Gokul2011]

Yes made custom index node and resolved it.

[Gokul2011]

Hi Opkar,

DAM search functionality is not  working ,while seaching it is still loading and loading but not getting any output.

I navigated as /assets/content/dam ---> search icon.

Using AEM6 SP2 . Is their any HF on top of SP2 to enable DAM search>

[Opkar_Gill]

Hi,

did you get any output to see which query is running?

Check the Explain Query Tool[1] to see what query is being run. "/etc/acs-tools/explain-query.html"

From the above page, run the query to see how long it takes to run and which indexes are being used.

You can also use QueryStat from the JMX console: /system/console/jmx/org.apache.jackrabbit.oak%3Aid%3D16%2Cname%3D"Oak+Query+Statistics"%2Ctype%3D"QueryStat"

Regards,

Opkar

[1] https://docs.adobe.com/docs/en/aem/6-0/deploy/upgrade/queries-and-indexing.html