Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-24206

As a Developer I want faster search, using spi cache & indexed columns

    Details

    • Sprint:
      Pollux Platform S9

      Description

      Data provided by cached storage can be used in Legacy Search Engine to avoid unnecessary database lookups and improve search performance.

      1. ContentTypeIdentifier criterion handler can be simplified by finding ContentType id, avoiding a subselect
      2. Field criterion handler can use cached searchable Field map data to avoid loading searchable fields for each use

        Issue Links

          Activity

          Hide
          Rui Silva (Inactive) added a comment -

          Tested and approved by QA.
          Since only a highly filled environment would reflect the performance enhancements affected to these changes, sanity tests on the search mechanism were executed for this issue, to assure all referred criteria for the search are working correctly.

          Show
          Rui Silva (Inactive) added a comment - Tested and approved by QA. Since only a highly filled environment would reflect the performance enhancements affected to these changes, sanity tests on the search mechanism were executed for this issue, to assure all referred criteria for the search are working correctly.
          Show
          Petar Spanja (Inactive) added a comment - Merged in https://github.com/ezsystems/ezpublish-kernel/commit/a8e2ec338fc3d0053e19fcfe382ec284444e8866 .
          Show
          Petar Spanja (Inactive) added a comment - Pull request: https://github.com/ezsystems/ezpublish-kernel/pull/1217

            People

            • Assignee:
              Unassigned
              Reporter:
              Petar Spanja (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2 days
                2d
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 2 hours, 45 minutes Time Not Required
                1d 2h 45m

                  Agile