jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luca Tagliani (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-2654) Query using JCR_SQL2 the repository starts retrieving nodes and hangs.
Date Mon, 14 Jun 2010 10:06:14 GMT
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.


Mime
View raw message