We run the .Net 4.0 ASP.Net application with SQL Server 2008 R2. I often run into database-related problems, and you often have to look into ways to optimize my SQL code (procedures, triggers, tasks, etc.). I recently learned about MongoDB and read several articles about it.
Invariably, all articles show that Mongo is much faster than SQL Server 2008 R2 in CRUD operations.
I also read that sourceforge is migrated from MySQL to MongoDB and claims to be able to handle 100x data.
So, impressed by these statistics, I went to the mongoDB website, I followed them with a short demonstration. That was amazing. But I could not find much information about other database related aspects like SProcs, triggers, jobs, cursors, Key, indexes, etc.
What is my main problem is that MongoDB has evolved enough that I can think about migrating from SQL Server 2008 R2. In addition, things like Keys, Indexex, SProcs, triggers, SQL jobs, etc. Do they exist in MongoDB? How good is their .Net integration API?
Does anyone know about this?
Thanks pending
source
share