[ 
https://issues.apache.org/jira/browse/OAK-1211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13828806#comment-13828806
 ] 

Antonio Sanso commented on OAK-1211:
------------------------------------

one of the "bottleneck" seems to be the query in 
UserProvider#getAuthorizableByPrincipal

[~alex.parvulescu] [~tmueller] [~mreutegg] can you spot anything it can be 
improved in this simple query?

{code}
SELECT * FROM [rep:Authorizable]WHERE [rep:principalName] = $principalName
{code}

is any index "missing"

> Add GetPoliciesTest
> -------------------
>
>                 Key: OAK-1211
>                 URL: https://issues.apache.org/jira/browse/OAK-1211
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: bench
>            Reporter: Antonio Sanso
>            Priority: Minor
>         Attachments: OAK1211-patch.txt
>
>
> Patch providing a GetPoliciesTest.
> So far Oak seems siginifcantly slower than Jackrabbit
> # GetPoliciesTest                  C     min     10%     50%     90%     max  
>      N
> Jackrabbit                         1      57      60      64      78     123  
>    897
> Oak-Tar                            1     946     952     968    1042    1292  
>     61
> to follow:
> - patch with the test
> - profile information



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Reply via email to