[
https://issues.apache.org/jira/browse/JCR-2654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luca Tagliani updated JCR-2654:
-------------------------------
Fix Version/s: 2.1.1
> Query using JCR_SQL2 the repository starts retrieving nodes and hangs.
> ----------------------------------------------------------------------
>
> Key: JCR-2654
> URL: https://issues.apache.org/jira/browse/JCR-2654
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.0.0, 2.1.0
> Reporter: Luca Tagliani
> Fix For: 2.1.1
>
> Attachments: QueryInSQL2.txt, QueryInXPATH.txt, snippet.java
>
>
> Using a test repository with 1000000 of nodes of type [wr:document].
> These nodes are contained in a hierarchy of [wr:folders] constructed like
> following:
> - 100 first level [wr:folder];
> - In each first level [wr:folder] there are 100 second level [wr:folder];
> - In each second level [wr:folder] there are 100 [wr:document] for a total of
> 1000000 [wr:document]
> NodeType [wr:document] has a string property called [wrprop:name].
> Searching for a single document using both XPATH and JCR_SQL2.
> The problem is that with XPATH the query executes in few ms, while using
> JCR_SQL2 the repository starts retrieving nodes and hangs.
> Attached are the logs of the execution an the snippet of code used.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
