MongoDB和Sql Server批量插入性能对比
有人做过 MongoDB 与 Sql Server 之间的批量插入比较吗？
如果是，哪一个表现更好？如果没有，我会这样做:)
我对此很好奇。
Has anyone done batch insert comparison between MongoDB vs Sql Server ?
If yes, which one performed better? if not, i ll do it :)
I m very curious about this.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
从苹果到橙子。基本上，您要求比较内存写入速度与写入磁盘的速度。 MongoDB 持久性模型是一个不断变化的目标，但通常 NoSQL 数据库不太重视本地持久性，例如。 耐久性怎么样？。在 v1.7.5 中，MongoDB 支持 WAL jurnaling，但 Mongo 提交不会刷新 WAL。要对相似行为进行等效比较，您必须发出
getLastError()在每次 MongoDB 提交之后，这将是最接近的关系事务提交。但随后有人会问你在使用什么quorums 为？不管你怎么切，它仍然是苹果和橙子。Apples to Oranges. Basically you're asking to compare the speed of writing in memory vs. the speed of writing to disk. MongoDB durability model is a moving target, but as a rule the NoSQL databases don't value local durability very much, eg. What about Durability?. With v1.7.5 MongoDB supports WAL jurnaling, but the Mongo commit is not flushing the WAL. To have an equivalent comparison of similar behavior you would have to issue
getLastError()after each MongoDB commit, which would be the closest equivalent of relational transaction commit. But then one would have to ask what are you using quorums for? No matter how you slice it, it will still be Apples and Oranges.