Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why Is MongoDB So Fast

Tags:

mongodb

I was showing my co-worker performance benchmarks of MongoDB vs SQL 2008 and while he believes MongoDB is faster, he doesn't understand how its possible. His logic, was that SQL has been around for decades, and has some of the smartest people working on it, and how can MongoDB; a relatively new kid on the block be so superior in performance? I wasn't able to really provide a solid and technical answer, and I was hoping you guys could assist.

like image 367
Justin Avatar asked Mar 03 '11 21:03

Justin


People also ask

Which is fast MongoDB or SQL?

MongoDB offers faster query processing but with an increased load and system requirements. Without knowing the purpose of use, it is not possible to classify SQL Databases or NoSQL Databases like MongoDB as better or worse than the other. There are various factors that drive the MongoDB vs SQL decision.

How fast MongoDB is?

How fast are MongoDB queries? Pretty darn fast. Primary key or index queries should take just a few milliseconds. Queries without indexes depend on collection size and machine specs, etc.

What is faster MongoDB or MySQL?

When it comes to the performance of MongoDB on unstructured data it is relatively very fast when compared to MySQL because of its document-based data storage. It Performs better than MySQL when working with Objects due to its JSON type Object storage.

Is MongoDB fast for big data?

It can process large amounts of real-time data very quickly because of in-memory calculations. MongoDB: MongoDB is a NoSQL database. It has a flexible schema. MongoDB stores huge amounts of data in a naturally traversable format, making it a good choice to store, query, and analyze big data.


1 Answers

MongoDB is fast because its web scale!

Its a fun video and well worth everyone watching, but it does answer your question - that most of the noSQL engines like MongoDB are not robust and not resilient to crashes and other outages. This security is what they sacrifice to gain speed.

like image 130
Will Avatar answered Oct 05 '22 15:10

Will