Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2699

Improve FTS query performance when using FTS indexes

    Details

    • Type: Enhancement
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 5.5
    • Component/s: Query
    • Labels:

      Description

      When executing a query that uses indexes, ModeShape uses the index to retrieve the applicable node keys and then for each node applies each of the filtering criteria from the search.

      For a FTS index, data extracted from a property using the getText() method is stored in the index. During the query criteria evaluation (i.e. during the result set iteration) the same method is called again for each node from the index (even though the simple fact that they are returned from the index means they match that criteria).

      This enhancement can be formulated generically as "do not apply query filtering criteria if this criteria matches a particular index". However, because a query criteria can look like A and B and C and an index can only apply to A, B and C must be applied to the results from the index.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                dalbani Damiano Albani
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: