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.1.0, 2.0.0
Reporter: Luca Tagliani
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.
