Uploaded image for project: 'Periscope'
  1. Periscope
  2. MGNLPER-168

JcrSearchResultSupplier generates inefficient queries

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 1.2.8
    • 1.2.4
    • None

      When generating a query JcrSearchResultSupplier will generate empty wildcard like as a clause when the searchterm is empty. This will create a bad performing query.

      It also uses wildcard characters on a fulltext query, which is unnecessary.

      Measure and record the times before the change and after the change in this ticket using the big data environment. We have a common place for the metrics here: https://www.notion.so/magnoliacms/Monitoring-and-tracking-metrics-d6c3037f7a584aa79911ecaf3d3bd22f

        Acceptance criteria

          1. JcrSearchResultSupplier.java
            14 kB
          2. EnhancedJcrSearchResultSupplier.java
            15 kB

              ricardo.gonzalez ricardo gonzalez
              rico.jansen Rico Jansen
              AuthorX
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved:
                Work Started:

                  Bug DoR
                  Task DoD

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0d
                    0d
                    Logged:
                    Time Spent - 0.5h
                    0.5h