Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization

• Main Authors: Wojciech Truskowski, Rafał Klewek, Maria Skublewska-Paszkowska
• Format: Article
• Language: English
• Published: Lublin University of Technology 2020-09-01
• Series: Journal of Computer Sciences Institute
• Subjects: virtualization; docker; database performance; oracle; mssql; mysql; postgresql
• Online Access: https://ph.pollub.pl/index.php/jcsi/article/view/2026

Oracle, MSSQL, MySQL and PostgreSQL are four of the most popular relational databases. They are often used in internet applications. This paper aims to compare the efficiency of these technologies in terms of speed using virtualization with Docker. No publications that include virtualization were found among previous papers. After review of the literature, it was hypothesized that the Oracle engine would be the fastest. During the research, a series of experiments was carried out using the application, in which tests for measuring the time of instruction execution were implemented. Each query was measured 100 times and the first measurement was rejected. The obtained results confirmed the hypothesis about the superiority of the Oracle database. As in previous studies, it proved to be the fastest, also using virtualization.