加索引测试：
- > db.users.getIndexes()
- [
- {
- "name" : "_id_",
- "ns" : "test.users",
- "key" : {
- "_id" : 1
- },
- "v" : 0
- }
- ]
- > db.users.ensureIndex({NewsId:1})
- > db.users.getIndexes()
- [
- {
- "name" : "_id_",
- "ns" : "test.users",
- "key" : {
- "_id" : 1
- },
- "v" : 0
- },
- {
- "_id" : ObjectId("4e2cc408572ff09d98851cb7"),
- "ns" : "test.users",
- "key" : {
- "NewsId" : 1
- },
- "name" : "NewsId_1",
- "v" : 0
- }
- ]
......................# MongoDB 加索引 插入1000W条测试
#...................
- ^_^[root@:~/svn/nugget/MongoDB/utest]#./insertData
- MongoDB Connected OK!
- Time:2019s:19419μs
......................# MongoDB 加索引
1000W条测试遍历测试 #...................
还是一样取最后一条数据，然后看下性能：
- ^_^[root@:/usr/local/mongodb/bin]#./mongo <bat.js
- MongoDB shell version: 1.8.2
- connecting to: test
- > var startTime = new Date();
- >
- > db.users.find({NewsId:"nxuvdqtjrrptoyildolesbkqmd"});
- { "_id" : ObjectId("4e2ccc2ea1ca039d82b9e4b3"), "NewsId" : "nxuvdqtjrrptoyildolesbkqmd" }
- >
- > (new Date().getTime()-startTime.getTime())/1000
- 0.022s
- > bye
......................# MongoDB 加索引 删除1000W条测试
#...................
- ^_^[root@:/usr/local/mongodb/bin]#./mongo 10.7.3.228 < bat.js
- MongoDB shell version: 1.8.2
- connecting to: 10.7.3.228/test
- > var startTime = new Date();
- >
- > db.users.remove()
- > (new Date().getTime()-startTime.getTime())/1000
- 570.782
- > bye
......................# MongoDB 加索引 1000W中删除一条测试
#...................
- ^_^[root@:/usr/local/mongodb/bin]#./mongo 10.7.3.228 < bat.js
- MongoDB shell version: 1.8.2
- connecting to: 10.7.3.228/test
- > var startTime = new Date();
- >
- > db.users.remove({"NewsId":"cikjwikamhtixoykrrfjnepkwu"})
- > (new Date().getTime()-startTime.getTime())/1000
- 0.025
- > bye
总结下测试数据吧：
没索引
添加 1 千万 记录
Time:207s:194125μs
查询 5.846s
删除全部 103.94s
删除最后一条 3.991s
有索引
添加 1 千万
记录 Time:2019s:19419μs
查询 0.022s
删除全部 570.782s
删除最后一条 0.025s
【转载】MongoDB 1000W级数据 Insert和Query和Delete性能测试,布布扣,bubuko.com
【转载】MongoDB 1000W级数据 Insert和Query和Delete性能测试
原文：http://www.cnblogs.com/jecob/p/3691681.html
