September 27, 2012 at 4:50 pm
Not a new article, but wanted to get some expertiese from those of you who may have had some experience with the NoSQL movement, and whether or not this 'test' holds water with truth. It appears to be an on-the-level, side-by-side test, but is this true of every possible situation? I have a hard time believing that MongoDB is that much better than SQL in overall performance.
http://blog.michaelckennedy.net/2010/04/29/mongodb-vs-sql-server-2008-performance-showdown/
September 27, 2012 at 4:54 pm
Websense block unfortunately, I'll have to remember to check this out when I get home or something similar.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 27, 2012 at 8:22 pm
I would say it's a limited use case. The models are much too simple to really be apple to apples. He also makes no effort to show what effort he might have done to improve things, so it's frankly just about impossible to dispute.
That said - I did notive that he didn't bother to mention in the article that he was running *local* install of mongodb while testing against a *remote* SQL server. He also sets up a level of DRI which he doesn't use while testing Mongo: so he slows the inserts in SQL down by enforcing FK's (worthwhile, but will put a hit on the perf), while not using it Mongo, but uses this to state that the joins "improve Mongo's performance" (not sure how since he didn't use them to begin with).
I have to think it's a bit of a hack job. Not to say that there aren't cases where a largely non-relational DB would work better, but I do think they don't actually make the case in the article (because they don't feel like they have to back it up with any SQL code, even run equivalent tests, etc...).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply