开发者

Batch Insert performance comparison of MongoDB and Sql Server

开发者 https://www.devze.com 2023-03-29 12:32 出处:网络
Has anyone done batch insert comparison between MongoDB vs Sql Server ? If yes, which one performed better? if not, i ll do it :)

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 t开发者_JAVA百科his.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消