测试机型 DELL R720
填充数据
</pre><pre name="code" class="javascript">for (var i = 1; i <= 100000000; i++){
var nj = Math.ceil(Math.random()*10);
var st=Math.round(Math.random());
db.user2.save({age:i, name:"wangcong", addr:"Beijing",location:"China",fid:nj,status:st})
};
查询条件
#无索引后 "millis" : 60260 耗时60s+
#加fid索引后 db.user2.ensureIndex({fid:1}) "millis" : 26932,
#增加关联索引 db.user2.ensureIndex({fid:1,status:1,age:-1}) "millis" : 20,
基于以上索引的其他查询
db.user2.find({'fid': 2}).limit(100).explain() "millis" : 0,
db.user2.find({'fid': 2}).sort({'age':-1}).limit(1000).explain() "millis" : 94,