SQL and NoSQL are different tools for different jobs. A couple of months ago we migrated a large site from SQL Server to MongoDB, it was a bumpy road and I decided to write this article to share what we learned:
http://www.wireclub.com/development/TqnkQwQ8CxUYTVT90/read
I'm shocked and mortified ... Check out <a href="http://bit.ly/v1cznd" rel="nofollow">http://bit.ly/v1cznd</a><p>Why would you conclude that MongoDB was "fast" and SQL Server was slow? Did you run SQL server on the same SSD's and multiple HDD's?<p>to willvarfar's comments, what was the real fsync cost and didn't you get ACID with SQL Server? Now, if ACID is not really required, and you really really need flexible schemas, then by all means ... I understand that you want distributed-queryable-notepad, not a relational database!
I also hosted a Q&A about our experience here on HN:
<a href="http://news.ycombinator.com/item?id=3141331" rel="nofollow">http://news.ycombinator.com/item?id=3141331</a>