Comparison of MySQL and MongoDB with focus on performance

摘要

Almost every web application uses a database for storing data. Storing and retrieving data causes a delay between request to the system and its response. This has an impact on user-experience. The market offers many types of databases and each is more suitable for different types of applications. The main difference is in data-structures which are used for data storing. Data-structures directly influence the performance of the database system and all dependent systems. In this paper, an overview and brief comparison of four types of NoSql databases has been made. Next, benchmark comparing performance of MongoDb and MySQL in different situation are discussed. Benchmarks are focused on operations such as inserting, updating, and deleting data with transactions and without transactions. The added value of the benchmarks is evaluated in terms of cost of indexed fields in the abovementioned situations.