Reasons for and against moving from SQL server to MongoDB

user_43337 0
Viewed 17276

I know this is a big question and it's not a yes or no answer but we develop web apps and are looking into using MongoDB for our persistence solution. Combining MongoDB with NoRM for object storage.

What I want to ask is what pitfalls have you experienced with switching from SQL to mongo? When is mongo simply not the right solution and is mongodb's advantages enough to move development from SQL?

mongodb nosql sql c#
6 Answers

I have been using MongoDB running on the Atlas cloud on AWS for many months and two major benefits stand out:

  • It is ludicrously fast compared to our relational dbs. I rarely see documents returned in more than 15ms, including the round trip across europe.
  • We stopped caring about schema or de-normalisation - we just take our c# object domian models and just serialise them into the database and it seems to work pretty well.
user_31408530
Related