COMPARATIVE PERFORMANCE ANALYSIS BETWEEN MYSQL AND MONGODB DATA STORAGE ENGINES TO SUPPORT DYNAMIC CONTENT OBJECTS
Roger Calderón Moreno, Edwin David Rubiano Bacca, Luis Alberto Parra Linares · Revista de Ingeniería Matemáticas y Ciencias de la Información · 2024
Comparative performance analyses enable users to take informed decisions on technologies beyond current market trends and/or commercial information from vendors. In this paper we present a comparative performance analysis between MySQL and MongoDB, based on data from the Dynamic Survey Manager at the Planes de Energización Rural Sostenible, Región Orinoquía project. First, we proposed a document-based data storage model to support the current relational model. This model allows a flexible structure and storage of information for the organization in future. Then, we configured the document-based model on MongoDB. Subsequently, we measured and compared performance times by using selected test scenarios. Finally, we found MongoDB has at least 40% better response times, in addition to the flexibility in the information structure and storage with respect to MySQL. MongoDB’s flexibility allows software developers to skip the object relational mapping within their data persistence layer, while supporting ACID-type transactions (Atomicity, Consistency, Isolation, Durability). Despite the positive results, we found a test scenario where MySQL outperformed MongoDB. For queries involving larger objects (e.g., > 100MB), MongoDB was 7.5% slower than its counterpart.