Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-79062

Either block from lowering to SBE or support whole bucket match TS queries

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • Query Integration

    Description

      This optimization is done for $match on the time field (the value in $match must be of type BSONDate, the optimization doesn't kick in for doubles) and avoids applying the event filter to each measurement in the bucket. The optimization is implemented via an optional state on $_internalUnpackBucket.

      According to Arun Banala the optimization improved the eligible queries by up to 30% so we don’t want to lose it but if it ends up tricky to implement in SBE we would need to block these queries from being lowered.

      Attachments

        Activity

          People

            backlog-query-integration Backlog - Query Integration
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: