ในโครงการของฉัน ฉันมีคอลเลกชันโพสต์และนี่คือโครงร่าง:
posts:{
title: {type: String, required: false},
text: {type: String, required: false},
plainDescription: {type: String, required: false},
isBlog: {type: Boolean,default: false},
type: {type: String, required: true, default:'USER', enum:["USER","GROUP"]},
information:{
tags:[],
users:[],
groups:[],
likes:[],
likesCount: {type: Number, default: 0},
dislikes:[],
dislikesCount:{type: Number, default: 0},
spams:[],
spamsCount: {type: Number, default: 0},
shares:[],
sharesCount: {type: Number, default: 0},
comments:[],
commentsCount:{type: Number, default: 0},
reply:[],
favorite: [],
favoriteCount:{type: Number, default: 0},
replyCount: {type: Number, default: 0}
},
authorId : { type: String, required: true},// Can be user Id or Group Id
authorName : { type: String, required: false},
isReply : { type: Boolean, default: false},
replyOf : { type: String, default: "",nullable: true, references: 'posts._id'},
isQuoteReyell : { type: Boolean, default: false},
quoteReyellOf : { type: String, default: "",nullable: true, references: 'posts._id'},
createdAt : { type: Date, default: Date.now},
createdBy : { type: String, required: false, references: 'users._id'},
creatorName : { type: String, required: true, references: 'users.userName'},
updatedAt : { type: Date, required: false,default: Date.now},
updatedBy : { type: String, required: false, references: 'users._id'},
updatorName : { type: String, required: false, references: 'users.userName'},
publishedAt : { type: Date, required: false},
isBlockedByAdmin : {type: Boolean,default: false},
isDelete : {type: Boolean,default: false},
isRss : {type: Boolean,default: false},
updatedObj : [],
sportName : {type: String, default: ''},
teamObj : []
},
และ ตามความต้องการของฉัน นี่คือแบบสอบถาม:
[{"$match":{"$and":[{"$or":[{"$and":[{"createdBy":{"$in":["5754c557bd961f3751ddd830"]}},{"createdAt":{"$lt":"2017-10-26T06:17:32.533Z"}},{"information.shares":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"sharedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}}]},{"$and":[{"isQuoteReyell":{"$ne":true}},{"updatedObj":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"type":"reyell","updatedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}},{"isReply":false}]},{"$and":[{"information.shares":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"sharedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}}]},{"$and":[{"isReply":true},{"createdBy":{"$in":["5754c557bd961f3751ddd830"]}},{"updatedAt":{"$lt":"2017-10-26T06:17:32.533Z"}}]},{"$and":[{"updatedObj":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"type":{"$ne":"reyell"},"updatedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}}]},{"$and":[{"createdBy":{"$in":["5754c557bd961f3751ddd830"]}},{"createdAt":{"$lt":"2017-10-26T06:17:32.533Z"}},{"isBlog":false},{"information.shares":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"sharedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}}]},{"$and":[{"isQuoteReyell":{"$ne":true}},{"updatedObj":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"type":"reyell","updatedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}},{"isReply":false}]},{"information.shares":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"sharedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}},{"$and":[{"isReply":true},{"createdBy":{"$in":["5754c557bd961f3751ddd830"]}},{"updatedAt":{"$lt":"2017-10-26T06:17:32.533Z"}},{"information.shares":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"sharedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}}]},{"$and":[{"information.shares":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"sharedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}},{"updatedObj":{"$elemMatch":{"userId":{"$in":["5754c557bd961f3751ddd830"]},"type":{"$ne":"reyell"},"updatedAt":{"$not":{"$gt":"2017-10-26T06:17:32.533Z"}}}}}]}]},{"isBlockedByAdmin":false},{"isDelete":false}]}},{"$unwind":"$updatedObj"},{"$match":{"$or":[{"$and":[{"updatedObj.type":"reyell"},{"updatedObj.userId":{"$in":["5754c557bd961f3751ddd830"]}}]},{"$and":[{"updatedObj.type":"create"}]}]}},{"$group":{"_id":"$_id","updated":{"$last":"$updatedObj"},"post":{"$last":"$$ROOT"}}},{"$sort":{"updated.updatedAt":-1}},{"$limit":15}]
ช่วยผมหน่อยนะครับว่าควรสร้างดัชนีหรือดัชนีผสมคอลัมน์ไหนครับจะได้ช่วยเพิ่มเวลาตอบสนองได้
