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

Port to master - JcrSearchResultSupplier generates inefficient queries.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: High High
    • 2.0.0
    • 2.0.0
    • 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

              ricardo.gonzalez ricardo gonzalez
              rico.jansen Rico Jansen
              AuthorX
              Votes:
              0 Vote for this issue
              Watchers:
              1 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 - 1h
                    1h