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

JcrSearchResultSupplier generates inefficient queries

    XMLWordPrintable

Details

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

    Description

      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

      Checklists

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:
                  Work Started:

                  Checklists

                    Bug DoR
                    Task DoD

                    Time Tracking

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