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.