[
https://issues.apache.org/jira/browse/OAK-1343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13877514#comment-13877514
]
Alex Parvulescu commented on OAK-1343:
--------------------------------------
I discussed this offline with Stefan.
There are 2 issues here:
- the query engine doesn't pick the reference index for this query, I'm looking
into why it doesn't - there are strong chances that it does so because there
are actually no references.
- CQ has a property index on the _rep:members_ which gets picked for the query
and it turns out to be terribly inefficient, which can be seen from the logs.
I'd also investigate the option of removing this index [~anchela] wdyt?
> Performance issue with login()/getGroupMembership() with many users
> -------------------------------------------------------------------
>
> Key: OAK-1343
> URL: https://issues.apache.org/jira/browse/OAK-1343
> Project: Jackrabbit Oak
> Issue Type: Improvement
> Components: core
> Affects Versions: 0.14
> Reporter: Stefan Egli
>
> (Tested with oak-snapshot as of ca 11:59AM, Jan 20, 2014 CET)
> When doing performance tests against oak I run into a major slowdown with
> each request showing the following WARNs:
> {code}
> 21.01.2014 11:42:51.625 *WARN* [FelixStartLevel]
> org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy
> Traversed 1000 nodes using index :weakreferen
> ces(294de355-7d9d-30b3-92d8-a1e6aab028cf) with filter Filter(, path=/*)
> ...
> 21.01.2014 11:42:55.345 *WARN* [FelixStartLevel]
> org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy
> Traversed 8000 nodes using index :weakreferen
> ces(294de355-7d9d-30b3-92d8-a1e6aab028cf) with filter Filter(, path=/*)
> {code}
> I traced this down to the following call:
> PrincipalProviderImpl.getGroupMembership
> In my performance test I create 1000 test users and it looks like the above
> call is currently very inefficient with that many users. This call happens
> during login(), so on each request you get the WARNs above, and subsequently
> each request is really slow.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
