MongoDB 1000W级数据 Insert和Query和Delete性能测试
加索引测试:
- > 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.find({NewsId:"csgsqdglbyfuwdjfkkrxgzyacc"});
- > db.users.remove()
- > (new Date().getTime()-startTime.getTime())/1000
- 570.782
- > bye
- ^_^[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.find({NewsId:"csgsqdglbyfuwdjfkkrxgzyacc"});
- > 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性能测试,古老的榕树,5-wow.com
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。