Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Indexing for XS:dateTime @jcr:created

Avatar

Level 6

Hi Team,

I have optimized all custom tags and all pages are loaded fast (installed oak:index  - damlucene.zip) . All of sudden , we can able to see more query trigerring on the below.

12.09.2015 18:39:58.851 *WARN*  GET /bin/querybuilder.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 1073000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [jcr:created] >= cast('2015-09-12T00:00:00.000+05:30' as date) and [jcr:created] <= cast('2015-09-13T00:00:00.000+05:30' as date) and isdescendantnode(a, '/content/dam/core-assets') /* xpath: /jcr:root/content/dam/core-assets//*[(@jcr:created >= xs:dateTime('2015-09-12T00:00:00.000+05:30') and @jcr:created <= xs:dateTime('2015-09-13T00:00:00.000+05:30'))] */, path=/content/dam/core-assets//*, property=[jcr:created=[[2015-09-12T00:00:00.000+05:30.., ..2015-09-13T00:00:00.000+05:30]]]); consider creating an index or changing the query

It been started quering while instance started and all the pages are loading very slow.

Why  it is quering suddenly with the above values?

1 Reply

Avatar

Level 10

what indexes are there in damlucene.zip ??