Shulou(Shulou.com)05/31 Report--

This article mainly explains "why MongoDB is more efficient than mysql". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "why MongoDB is more efficient than mysql".

The first is the memory mapping mechanism, in which the data is not persisted to the storage device, but temporarily stored in memory, which improves the efficiency on the IO and the performance loss of the operating system to the storage media. (after all, memory reads fastest) second, NoSQL doesn't use sql, it just doesn't use relationships. The existence of no relationship means that each data is like having a separate storage space, and then an aggregation index points to it. Search performance is sure to improve. Third, language. Using javascript syntax for operations is more efficient and straightforward. These are the reasons why MongoDB is more efficient for relational databases. However, we can not only focus on efficiency, this kind of database design also brings drawbacks. For example, the maintenance of data relations will bring a lot of redundant data, client code needs a large number of IO operations against the database, data mining is difficult to achieve and so on.

But MongoDB also has some disadvantages compared to MySQL:

Transaction operations are not supported

Take up too much space

MongoDB does not have such mature maintenance tools as MySQL.

Unable to query associated tables, which is not suitable for relational data

Complex aggregation operations are created through mapreduce and are slow

Data errors caused by free and flexible file storage format

Thank you for reading, the above is the content of "Why MongoDB is more efficient than mysql". After the study of this article, I believe you have a deeper understanding of why MongoDB is more efficient than mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.