MongoDB$匹配$组查询慢

Question

所以我对大约500k文档有以下查询，它在数据库端非常慢：

db.collection('news').aggregate(
    [
      {
        $match: {
          feeds: { $in: feeds },
          createdAt: { $lte: lastPostDate },
          deleted: {
            $exists: false
          }
        }
      },
      {
        $group: {
          _id: { title: '$title' },
          id: { $first: '$_id' },
          title: { $addToSet: '$title' },
          source: { $first: '$source' },
          shortid: { $first: '$shortid' },
          stats: { $first: '$stats' },
          log: { $first: '$log' },
          createdAt: { $first: '$createdAt' },
          feedUpdated: { $first: '$feedUpdated' },
          media: { $first: '$media' },
          title: { $first: '$title' }
        }
      },
      { $sort: sort },
      {
        $skip: limit * (page - 1)
      },
      {
        $limit: limit * 1
      }
    ],
    {
      allowDiskUse: true,
      cursor: {}
    }
)

我知道allowDiskUse使它变慢，但如果禁用它，我会得到：

MongoError：超过$group的内存限制，但不允许外部排序。通过允许磁盘使用：真来选择加入。

Answer 1

let aggregation = MongoSchemaModel.aggregate([]); 
aggregation.options = { allowDiskUse: true }; 
aggregation.exec((err, data) => {});

或

let aggregation = MongoSchemaModel.aggregate([], { allowDiskUse: true });
aggregation.exec((err, data) => {});

参考：-https://mkyong.com/mongodb/mongodb-sort-exceeded-memory-limit-of-104857600-bytes/