Jackrabbit Content Repository
  1. Jackrabbit Content Repository
  2. JCR-2654

Query using JCR_SQL2 the repository starts retrieving nodes and hangs.

    Details

      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.

      1. snippet.java
        0.5 kB
        Luca Tagliani
      2. QueryInXPATH.txt
        4 kB
        Luca Tagliani
      3. QueryInSQL2.txt
        9 kB
        Luca Tagliani

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Luca Tagliani
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development