Uploaded image for project: 'Jackrabbit Content Repository'
  1. Jackrabbit Content Repository
  2. JCR-2959

SQL2 QueryEngine should use Lucene for sort

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 2.2.1
    • None
    • jackrabbit-core
    • None

    Description

      Currently all SQL2 queries with "order by" expression are sorted with Collections.sort - which is slow and very bad if there are lots of hits. Lucene should be used for sorting hits instead.

      Attachments

        1. JCR-2959.patch
          35 kB
          Alex Deparvu

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. JCR-2830 JCR-SQL2 : Query on large node-set is (too) slow even when offset and limit is used

          • Major - Major loss of function.
          • Open
          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. JCR-3047 OperandEvaluator should be able to handle Nodes as well, not just Rows

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. JCR-3446 Implement sort by node name for XPATH

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              robert_seidel Robert Seidel
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: