Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework

Main Article Content

DOI

Rafał Wodyk

rafal.wodyk@pollub.edu.pl

Maria Skublewska-Paszkowska

maria.paszkowska@pollub.pl

Abstract

Many database implementations are supported by application frameworks that can affect their performance. The paper presents a comparison of the performance of SQL Server, MySQL and PostgreSQL relational databases based on an application written in PHP using the Laravel framework. The time of performance for various types of queries, both simple and using column and table concatenation was evaluated. The obtained results for the same database structures differed depending on the operations performed on the databases. Looking at the entirety of the research conducted, it can be concluded that in the case of databases in which the number of records is not too large (up to 1000 records) and the technical parameters of the device on which the database is running are of low or medium class, MySQL performs very well.

Keywords:

DBMS; relational model; performance analysis; framework Laravel; SQL Server; MySQL, PostgreSQL

References

Article Details

Wodyk, R., & Skublewska-Paszkowska, M. (2020). Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework. Journal of Computer Sciences Institute, 17, 358–364. https://doi.org/10.35784/jcsi.2279