Is there a big speed difference between Mongo and Mysql(MyIsam)?

Question

Giving the following situation:

• over 10 million rows of data
• using a single collection in Mongo, with no embedded relations just a simple document but with many fields
• using a Mysql(MyIsam Engine) table with the same fields.

--

• Is the select speed better in any of them ?
• Are updates/inserts faster in any of them ?
• Are there any significantly advantages in any of them ?

Answer 1

Assuming that you are running benchmarks on the same kind of operating system, everything will come down to your data structure. For instance, in both Mongo & Mysql, you have indexes, but if you do not use an index, mysql will beat mongo, if you index mongo properly, they would be close. Mongo is better for unstructured data, where Mysql is better for structured and will typically out perform an unstructured/NoSQL type data store. DML (updates/inserts/deletes) may be faster by index with Mysql depending upon good data design.

Advantages are based on the architecture. For instance Mysql is traditional row based transaction type (OLTP). Mongo is a for unstructured data, No schema is necessary. Usually systems like this use key/value pairs to identify their objects which gives speedy access to the data on disk.