Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework
Rafał Wodyk
rafal.wodyk@pollub.edu.plPolitechnika Lubelska (Poland)
Maria Skublewska-Paszkowska
Lublin University of Technology (Poland)
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, PostgreSQLReferences
Relacyjne bazy danych – dlaczego warto je znać?, https://teamquest.pl/blog/461_relacyjne-bazy-danych-dlaczego-warto-je-znac, [15.09.2020]
Google Scholar
C. Truica, A. Boicea, Asynchronous Replication in Microsoft SQL Server, PostgreSQL and MySQL, International Conference on Cyber Science and Engineering, Guangzhou, 2013.
Google Scholar
M. Grudzień, K. Korgol, D. Gutek, Porównanie możliwości wykorzystania oraz analiza wydajności baz danych na systemach mobilnych, Journal of Computer Sciences Institute 2 (2016) 133-139.
DOI: https://doi.org/10.35784/jcsi.129
Google Scholar
8 Best PHP Frameworks in 2020, https://athemes.com/collections/best-php-frameworks/, [15.09.2020]
Google Scholar
B. Masood-Al-Farooq, SQL Server 2014 Development Essentials, Packt Publishing, Birmingham, 2014.
Google Scholar
SQL Server Tutorial, https://www.sqlservertutorial.net, [01.05.2020]
Google Scholar
Środowisko MS SQL Server, https://www.sqlpedia.pl/srodowisko-ms-sql-server/, [01.05.2020]
Google Scholar
MYSQL, https://vavatech.pl/technologie/bazy-danych/mysql, [26.04.2020]
Google Scholar
PostgreSQL vs. MySQL: Which One Is Better for Your Use Case, https://www.xplenty.com/blog/postgresql-vs-mysql-which-one-is-better-for-your-use-case/, [26.04.2020]
Google Scholar
Supported Platforms: MySQL Database, https://www.mysql.com/support/supportedplatforms/database.html, [16.10.2020]
Google Scholar
S. Juba, A. Volkov, Learning PostgreSQL 11, Packt Publishing, Birmingham, 2019.
Google Scholar
S. Riggs, G. Ciolli: PostgreSQL 9 Administration Cookbook, Second Edition, Packt Publishing, Birmingham, 2015.
Google Scholar
PostgreSQL Vs. MySQL: Differences In Performance, Syntax, And Features, https://blog.panoply.io/postgresql-vs.-mysql, [26.04.2020]
Google Scholar
Authors
Maria Skublewska-PaszkowskaLublin University of Technology Poland
Statistics
Abstract views: 3313PDF downloads: 2151
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.