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

Investigate performance of artificial query on SSB dataset

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

      Here is the query:

       

      db.order_lineitem.aggregate(
      [
          {
              $match: {
                  $and: [
                      { "order.o_orderdate": { $gte: ISODate("1992-01-01") } },
                      { "order.o_orderdate": { $lte: ISODate("1996-01-01") } },
                      { l_discount: { $gte: 0.1 } },
                      { l_discount: { $lte: 0.3 } }
                  ],
                  l_quantity: {
                      $lte: 25
                  }
              },
          },
          {
              $group: {
                      _id: 1,
                      revenue: {
                          $sum: {
                              $multiply: [
                                  "$l_extendedprice",
                                  "$l_discount"
                              ]
                          }
                      }
                  }
              }
          ]
      ) 

        1. performance.py
          8 kB
          Mohammad Dashti
        2. ssb.yaml
          0.7 kB
          Mohammad Dashti
        3. ssb-improved.yaml
          0.7 kB
          Mohammad Dashti
        4. ssb-improved-corrected.yaml
          0.7 kB
          Mohammad Dashti
        5. ssb-orig.yaml
          0.8 kB
          Mohammad Dashti
        6. ssb-orig-corrected.yaml
          0.8 kB
          Mohammad Dashti

            Assignee:
            mohammad.dashti@mongodb.com Mohammad Dashti (Inactive)
            Reporter:
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: