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?