是否有任何有效的方法可以以最新的第一顺序对给定的mongodb数据进行分页，并避免对大量数据进行排序超出内存限制？

Question

我给出了如下样本数据收集。我正在尝试在最新的第一订单中获取结果，因此我使用了分页并分别对其进行了排序。但是当我尝试对大量数据进行排序时，例如 API 命中限制 100 .然后它抛给我错误

"消息"：":: 排序导致的查找命令:: 执行器错误超过内存限制33554432字节，但未选择加入外部排序。中止操作。通过允许磁盘使用：true选择加入。"

{
  "success": true,
  "message": "",
  "status": {},
  "data": {
    "docs": [
 {
        "_id": "5d1dbe9cad2de907c4a6c888",
        "requestedBy": {
          "adminId": "1",
          "adminName": "JJ"
        },
        "reason": "Testing",
        "payload": [
          {
            "recipient": {
              "to": "[e-mail]",
              "from": "[e-mail]",
              "bcc": "[e-mail]"
            },
            "data": {
              "b_name": "Cloud",
              "amount": 100,
              "l_id": 10,
              "date": "10",
              "month": "Jul",
              "year": "2019"
            },
            "template": {
              "name": "Reminder",
              "type": "EMAIL"
            }
          }
],
        "createdAt": "2019-07-04T08:53:48.129Z",
        "updatedAt": "2019-07-04T08:53:48.129Z",
        "__v": 0,
        "id": "5d1dbe9cad2de907c4a6c888"
      }
    ]
}

}

const mongoose = require("mongoose");
const mongoosePaginate = require("mongoose-paginate-v2");

mongoosePaginate.paginate.options = {
  lean: true,
  limit: 200,
  sort:{
    createdAt: -1
  }
};
const MODEL_NAME = "data";

const dSchema = mongoose.Schema(
  {
    requestedBy: {
      adminId: String,
      adminName: String
    },
    reason: String,
    payload: mongoose.Mixed
  },
  { timestamps: true }
);

// Plugins
dSchema.plugin(mongoosePaginate);

// Methods to interact with models
dSchema.statics.getTasks = (query, options) => {
  return mongoose.model(MODEL_NAME).paginate(query, options);
};

Answer 1

https://mongoosejs.com/docs/guide.html#indexes

https://mongoosejs.com/docs/guide.html#timestamps

https://docs.mongodb.com/manual/tutorial/optimize-query-performance-with-indexes-and-projections/

索引还可以提高对给定字段进行常规排序的查询的效率。

https://docs.mongodb.com/manual/indexes/#create-an-index

将索引添加到 createdAt 以提高查询性能

dSchema.index({ "createdAt" : -1 });

https://www . MongoDB . com/blog/post/performance-best-practices-indexing