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

Investigate performance of artificial SSB query

    • Type: Icon: Task Task
    • Resolution: Incomplete
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None

      db.order_lineitem.aggregate([
          {
              $match: {
                  $and: [
                      { "order.o_orderdate": { $gte: ISODate("1992-01-01") } },
                      { "order.o_orderdate": { $lte: ISODate("1996-01-01") } },
                  ]
              },
          },
          {
              $group: {
                      _id: "$order.o_orderkey",
                      priority: { $last: "$order"},
                      someSum: {
                          $sum: "$l_extendedprice"
                      },
                      anotherSum1: {
                          $sum: "$l_discount"
                      },
                      anotherSum2: {
                          $sum: "$l_tax"
                      },
                      anotherSum3: {
                          $sum: "$l_quantity"
                      },
                      count: { $sum: 1 }
                  }
              }
          ]
      )  
      • Investigate perf, see if there's any low-hanging fruit
      • if no low hanging fruit, I'd still like to understand where all the time is spent in this query

       

            Assignee:
            mohammad.dashti@mongodb.com Mohammad Dashti (Inactive)
            Reporter:
            colby.ing@mongodb.com Colby Ing
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: