I' seeing logs like
00:11:55,702 DEBUG jackrabbit.JackrabbitQuery.getQueryString() - line
242 [127.0.0.1] - queryString:
/jcr:root/nen:content/pages-en//element(*,nen:resource)[@nen:type =
'0']
00:11:55,706 WARN
strategy.ContentMirrorStoreStrategy$PathIterator.fetchNextPossiblyDuplicate()
- line 278 [127.0.0.1] - Traversed 1000 nodes using index
jcr:mixinTypes with filter Filter(query=select [jcr:path],
[jcr:score], * from [nen:resource] as a where [nen:type] = '0' and
isdescendantnode(a, '/nen:content/pages-en') /* xpath:
/jcr:root/nen:content/pages-en//element(*,nen:resource)[@nen:type =
'0'] */, path=/nen:content/pages-en//*, property=[nen:type=0])
[...]
which I guess indicates that I need an index here (on jcr:path)?
I've currently set up indexes in an RepositoryInitializer class with
IndexUtils.createIndexDefinition(index, "nen:resourceid", true, false,
org.elasticsearch.common.collect.ImmutableList.of("nen:resourceid"),
null);
IndexUtils.createIndexDefinition(index, "nen:type", true, false,
org.elasticsearch.common.collect.ImmutableList.of("nen:type"), null);
IndexUtils.createIndexDefinition(index, "nen:name", true, false,
org.elasticsearch.common.collect.ImmutableList.of("nen:name"), null);
My /oak:index node contains index definitions for
nen:type, acPrincipalName, uuid, nen:resourceid,nen:name, nodetype,
reference, principalName, lucene, authorizableId.
--
-Tor
