You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Przemo Pakulski (JIRA)" <ji...@apache.org> on 2015/04/15 17:57:59 UTC

[jira] [Commented] (OAK-2777) Minimize the cost calculation for queries using reference restrictions.

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

Przemo Pakulski commented on OAK-2777:
--------------------------------------

I have working patch which makes above query running about 3 times faster on my env. What do you think, is it way to go ?

> Minimize the cost calculation for queries using reference restrictions.
> -----------------------------------------------------------------------
>
>                 Key: OAK-2777
>                 URL: https://issues.apache.org/jira/browse/OAK-2777
>             Project: Jackrabbit Oak
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.1.2, 1.2
>            Reporter: Przemo Pakulski
>
> According to the javadocs (QueryIndex) minimum cost for index is 1. Currently ReferenceIndex returns this minimum value, when it can be used for the query.
> But even than remaining indexes are still calculated. We could skip cost calculation of remaining indexes if we achieved the minimum cost already.
> It will speed up all queries which can leverage the reference Index.
> Example query:
> SELECT * FROM [nt:base] WHERE PROPERTY([rep:members], 'WeakReference') = '345bef9b-ffa1-3e09-85df-1e03cfa0fb37'



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)