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

Posted to dev@jackrabbit.apache.org by "Julian Reschke (Jira)" <ji...@apache.org> on 2020/08/28 10:56:00 UTC

[jira] [Closed] (JCR-3423) SQL2 Query Runs Slower Than XPath/SQL1

     [ https://issues.apache.org/jira/browse/JCR-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Reschke closed JCR-3423.
-------------------------------

> SQL2 Query Runs Slower Than XPath/SQL1
> --------------------------------------
>
>                 Key: JCR-3423
>                 URL: https://issues.apache.org/jira/browse/JCR-3423
>             Project: Jackrabbit Content Repository
>          Issue Type: Improvement
>          Components: jackrabbit-core, query
>    Affects Versions: 2.3
>            Reporter: Zacchaeus Sim
>            Priority: Major
>
> Query using XPATH query:
> /jcr:root/content//*[@sling:resourceType='foundation/components/text']
> This will take around 2-10ms if you execute it several times.
>  Do the same with a SQL2 query:
> SELECT * FROM [nt:unstructured] AS ref WHERE ISDESCENDANTNODE([/content]) AND CONTAINS(ref.[sling:resourceType],'foundation/components/text')
> This will take around 25-35ms if you execute it several times.
> This is just one use case where XPATH query is much faster.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)