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

Port to master - JcrSearchResultSupplier generates inefficient queries.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • High
    • 2.0.0
    • 2.0.0
    • 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:
                0 Vote for this issue
                Watchers:
                1 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 - 1h
                      1h