[JCR-2654] Query using JCR_SQL2 the repository starts retrieving nodes and hangs.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0, 2.1
• Component/s: jackrabbit-core
• Labels: jackrabbit query sql2 xpath
• Assignee: Unassigned
• Reporter: Luca Tagliani
• Created: 14/Jun/10 10:03
• Updated: 04/Aug/10 14:17

Description

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.