我使用赛尔斯Js和MongoDB数据库。我想优化下面的查询。
Users.findOne({id:user_id})
.populate('educations')
.populate('educations.educationlinks')
.populate('educations.educationlinks.verify_request_id')
.populate('educations.educationlinks.verify_request_id.user_id')
.populate('educations.educationlinks.verify_request_id.user_id.company_id')
.exec(function(err, user){
return res.json(user);
});
请帮帮我……
发布于 2018-08-02 05:38:57
默认情况下,对于MongoDB查询,SailsJS不区分大小写。要优化MongoDB查询性能,请尝试使用以下命令在Mongo查询代码( connections .js文件中的MongoDB代码)中强制区分大小写:
wlNext: {
caseSensitive: true
}
//For Example:
someMongodbServer: {
adapter: 'sails-mongo',
host: 'localhost',
port: 27017,
database: 'sails_demo' //optional
wlNext: {
caseSensitive: true
}
},
希望这能有所帮助!
其他资源:
https://docs.mongodb.com/manual/tutorial/optimize-query-performance-with-indexes-and-projections/
https://stackoverflow.com/questions/51518868
复制相似问题