-
Type: Investigation
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Not Needed
The explain output of a pipeline containing $_internalUnpackBucket and $group has been changed due to optimization.
Description of Linked Ticket
Summary
Implement in the classic Engine selected optimizations recommended by the Time-Series Query Performance Improvements Spike project.
Motivation
TIme Series query performance has not lived up to expectations, leading to dissatisfied customers and lost opportunities.
Query team has completed a prior Spike to investigate different approaches to optimize Time Series query performance. This project is a continuation of that work, with the aim of implementing the recommended solutions in production.
Due to the existing feature and performance gap in SBE, we have decided to implement these optimizations first in the classic engine, in order to deliver the gains confirmed in the Spike project.
This is part of the wider Time Series Initiative.