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

Rafał Wodyk

rafal.wodyk@pollub.edu.pl
Politechnika 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, PostgreSQL

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

Download


Published
2020-12-30

Cited by

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

Authors

Rafał Wodyk 
rafal.wodyk@pollub.edu.pl
Politechnika Lubelska Poland

Authors

Maria Skublewska-Paszkowska 

Lublin University of Technology Poland

Statistics

Abstract views: 3313
PDF downloads: 2151