[ https://issues.apache.org/jira/browse/OAK-2720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marcel Reutegger reassigned OAK-2720: ------------------------------------- Assignee: Chetan Mehrotra [~chetanm], assigning this issue to you because you created the patch and mentioned you want to apply it. > Misleading traversal warning message while performing query > ----------------------------------------------------------- > > Key: OAK-2720 > URL: https://issues.apache.org/jira/browse/OAK-2720 > Project: Jackrabbit Oak > Issue Type: Bug > Components: query > Reporter: Chetan Mehrotra > Assignee: Chetan Mehrotra > Fix For: 1.2 > > Attachments: OAK-2720.patch > > > Currently {{ContentMirrorStoreStrategy}} logs a traversal warning if the > property index performs node traversal of more than 10000 (default). > The intention here being to warn the end user that traversing so many nodes > would cause performance issue. Traversal in itself might happen due to many > reason like > # Query not using right index. If the query has two property restriction and > one of them is more broad while other is more selective and index is defined > only for first then more traversal would be performed. The warning should > help the user to create a new index for second property > # Caller is fetching way more result - Query might end with say 50k result > and caller is reading all. Such warning would help user to probably go for > pagination > So above are valid cases. However currently warning is also seen even if end > result set is small say 100 but indexed paths are deep. As > {{ContentMirrorStoreStrategy}} mirrors the path structure the current > counting logic also counts the intermediate traversals. This warning is then > misleading as how this internal structure is created is an implementation > details of index which end user does not have any control. This leaves > following options > # Use different storage strategy which is more efficient in storage > # Do not count the intermediate nodes traversed within index path and instead > only count the matching node -- This message was sent by Atlassian JIRA (v6.3.4#6332)