Uploaded image for project: '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.

        Attachments

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

          Activity

            People

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

              Dates

              • Created:
                Updated: