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) logged work - 01/Apr/15 8:35 AM
          • Time Spent:
            5 hours, 15 minutes
             

            implement

          Petar Spanja (Inactive) made changes -
          Assignee Petar Spanja [ petar.spanja@ez.no ]
          Petar Spanja (Inactive) made changes -
          Status Backlog [ 10000 ] Development [ 3 ]
          Show
          Petar Spanja (Inactive) added a comment - Pull request: https://github.com/ezsystems/ezpublish-kernel/pull/1217
          Petar Spanja (Inactive) made changes -
          Status Development [ 3 ] Development Review [ 10006 ]
          Petar Spanja (Inactive) logged work - 03/Apr/15 2:00 AM
          • Time Spent:
            5 hours, 30 minutes
             

            implementation

          Petar Spanja (Inactive) made changes -
          Remaining Estimate 2 days [ 57600 ] 4 hours [ 14400 ]
          Show
          Petar Spanja (Inactive) added a comment - Merged in https://github.com/ezsystems/ezpublish-kernel/commit/a8e2ec338fc3d0053e19fcfe382ec284444e8866 .
          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 ]
          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.
          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 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Confirmed Confirmed
          3h 10m 1 André Rømcke 31/Mar/15 5:53 PM
          Confirmed Confirmed Backlog Backlog
          2s 1 André Rømcke 31/Mar/15 5:53 PM
          Backlog Backlog Development Development
          16h 12m 1 Petar Spanja (Inactive) 01/Apr/15 10:06 AM
          Development Development Development Review Development Review
          3h 41m 1 Petar Spanja (Inactive) 01/Apr/15 1:47 PM
          Development Review Development Review Development Review done Development Review done
          5d 20h 23m 1 Petar Spanja (Inactive) 07/Apr/15 10:11 AM
          Development Review done Development Review done Documentation Review done Documentation Review done
          5s 1 Petar Spanja (Inactive) 07/Apr/15 10:11 AM
          Documentation Review done Documentation Review done QA QA
          1h 52m 1 rui.silva@ez.no 07/Apr/15 12:03 PM
          QA QA Closed Closed
          1d 4h 6m 1 rui.silva@ez.no 08/Apr/15 4:09 PM
          Closed Closed Reopened Reopened
          36d 14h 32m 2 Petar Spanja (Inactive) 15/May/15 6:42 AM
          Reopened Reopened Closed Closed
          1s 2 Petar Spanja (Inactive) 15/May/15 6:42 AM

            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