Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-6351

Investigate changes in PM-3050: Time Series Query Performance Optimizations

    XMLWordPrintableJSON

Details

    • Icon: Investigation Investigation
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • No version
    • None
    • None
    • None

    Description

      Original Downstream Change Summary

      The explain output of a pipeline containing $_internalUnpackBucket and $group has been changed due to optimization.

      Description of Linked Ticket

      Epic Summary

      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.

      Documentation

      Product Description
      Scope Document
      Design Document

      Attachments

        Activity

          People

            Unassigned Unassigned
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: