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

          Petar Spanja (Inactive) created issue -
          Petar Spanja (Inactive) made changes -
          Field Original Value New Value
          Description Cached Field data provided by cached storage can be used in Legacy Search Engine to avoid unnecessary database lookups and improve search performance. Cached Field 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
          Petar Spanja (Inactive) made changes -
          Original Estimate 2 days [ 57600 ]
          Remaining Estimate 2 days [ 57600 ]
          Petar Spanja (Inactive) made changes -
          Summary As a Developer I want faster search with Legacy Search Engine, using cached Field data As a Developer I want faster search with Legacy Search Engine, using cached storage data
          Petar Spanja (Inactive) made changes -
          Description Cached Field 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
          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
          André Rømcke made changes -
          Summary As a Developer I want faster search with Legacy Search Engine, using cached storage data As a Developer I want faster search, using spi cached & using indexed columns
          André Rømcke made changes -
          Affects Version/s 5.4.1 [ 13886 ]
          Affects Version/s 5.3.4 [ 13879 ]
          Affects Version/s 5.4.2 [ 13979 ]
          André Rømcke made changes -
          Fix Version/s 5.3.5 [ 13889 ]
          Fix Version/s 5.4.2 [ 13979 ]
          André Rømcke made changes -
          Sprint Pollux Platform S9 [ 64 ]
          André Rømcke made changes -
          Fix Version/s 2015.03 [ 14179 ]
          André Rømcke made changes -
          Status Open [ 1 ] Confirmed [ 10037 ]
          André Rømcke made changes -
          Status Confirmed [ 10037 ] Backlog [ 10000 ]
          André Rømcke made changes -
          Rank Ranked higher
          André Rømcke made changes -
          Summary As a Developer I want faster search, using spi cached & using indexed columns As a Developer I want faster search, using spi cached & indexed columns
          André Rømcke made changes -
          Summary As a Developer I want faster search, using spi cached & indexed columns As a Developer I want faster search, using spi cache & indexed columns
          Petar Spanja (Inactive) made changes -
          Assignee Petar Spanja [ petar.spanja@ez.no ]
          Petar Spanja (Inactive) made changes -
          Status Backlog [ 10000 ] Development [ 3 ]
          Petar Spanja (Inactive) made changes -
          Status Development [ 3 ] Development Review [ 10006 ]
          Petar Spanja (Inactive) made changes -
          Remaining Estimate 2 days [ 57600 ] 4 hours [ 14400 ]
          Petar Spanja (Inactive) made changes -
          Status Development Review [ 10006 ] Development Review done [ 10028 ]
          Petar Spanja (Inactive) made changes -
          Status Development Review done [ 10028 ] Documentation Review done [ 10011 ]
          Rui Silva (Inactive) made changes -
          Status Documentation Review done [ 10011 ] QA [ 10008 ]
          Assignee Petar Spanja [ petar.spanja@ez.no ] Rui Silva [ rui.silva@ez.no ]
          Rui Silva (Inactive) made changes -
          Assignee Rui Silva [ rui.silva@ez.no ]
          Status QA [ 10008 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Petar Spanja (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Petar Spanja (Inactive) made changes -
          Remaining Estimate 4 hours [ 14400 ] 0 minutes [ 0 ]
          Time Spent 5 hours, 15 minutes [ 18900 ]
          Worklog Id 54537 [ 54537 ]
          Petar Spanja (Inactive) made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Petar Spanja (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Petar Spanja (Inactive) made changes -
          Time Spent 5 hours, 15 minutes [ 18900 ] 1 day, 2 hours, 45 minutes [ 38700 ]
          Worklog Id 54543 [ 54543 ]
          Petar Spanja (Inactive) made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          André Rømcke made changes -
          Workflow eZ Engineering Scrumban Workflow [ 67023 ] EZ* Development Workflow [ 85797 ]
          André Rømcke made changes -
          Remote Link This issue links to "Page (eZ Documentation)" [ 16119 ]
          Alex Schuster made changes -
          Workflow EZ* Development Workflow [ 85797 ] EZEE Development Workflow [ 124713 ]
          Alex Schuster made changes -
          Workflow EZEE Development Workflow [ 124713 ] EZEE and EZP Story Workflow [ 127904 ]

            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