Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework
Article Sidebar
Open full text
Issue Vol. 17 (2020)
-
Impact of the persistence layer implementation methods on application per-formance
Kamil Siebyła, Maria Skublewska-Paszkowska326-331
-
Analysis of positioning errors of the GPS navigation receivers
Łukasz Budzyński, Eligiusz Pawłowski332-338
-
Analysis and comparison of programming frameworks used for automated tests
Damian Gromek, Dariusz Gutek339-344
-
An Examination of Selected Websites Availability For People With Various Types of Disabilities
Mateusz Proskura, Sylwia Podkościelna, Grzegorz Kozieł345-350
-
Comparative analysis of web application performance testing tools
Agata Kołtun, Beata Pańczyk351-357
-
Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework
Rafał Wodyk, Maria Skublewska-Paszkowska358-364
-
Comparative analysis of microcontrollers from the Arduino family and other compatible ones
Przemysław Suszek, Tomasz Szymczyk365-372
-
Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison
Arkadiusz Solarz, Tomasz Szymczyk373-378
-
Comparative analysis of medical images watermarking methods
Sylwia Duda, Dominik Fijałek, Grzegorz Kozieł379-383
-
Performance comparison of web services using Symfony, Spring, and Rails examples
Patryk Lubartowicz, Beata Pańczyk384-389
-
Modeling of COVID-19 cases of selected states in Nigeria using linear and non-linear prediction models
Babatunde Abdulrauph Olarenwaju, Igboeli Uchenna Harrison390-395
-
Comparative analysis of the technology used to create multi-platform applications on the example of NW.js and Electron
Maciej Hołowiński, Beata Pańczyk396-400
-
Faster R-CNN model learning on synthetic images
Błażej Łach, Edyta Łukasik401-404
-
Enviromental data visualisation using Delaunay triangulation
Mateusz Nowosad405-411
-
Comparison of methods and tools for generating levels of details of 3D models for popular game engines
Michał Tomecki412-416
-
Analysis of the use of the UTAUT model for modeling the information technology acceptance process
Magdalena Czerwinska417-420
-
Transport preferences of the students and employers in Lublin University of Technology
Jakub Bis, Magda Kojro421-427
Main Article Content
DOI
Authors
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:
References
Relacyjne bazy danych – dlaczego warto je znać?, https://teamquest.pl/blog/461_relacyjne-bazy-danych-dlaczego-warto-je-znac, [15.09.2020]
C. Truica, A. Boicea, Asynchronous Replication in Microsoft SQL Server, PostgreSQL and MySQL, International Conference on Cyber Science and Engineering, Guangzhou, 2013.
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
8 Best PHP Frameworks in 2020, https://athemes.com/collections/best-php-frameworks/, [15.09.2020]
B. Masood-Al-Farooq, SQL Server 2014 Development Essentials, Packt Publishing, Birmingham, 2014.
SQL Server Tutorial, https://www.sqlservertutorial.net, [01.05.2020]
Środowisko MS SQL Server, https://www.sqlpedia.pl/srodowisko-ms-sql-server/, [01.05.2020]
MYSQL, https://vavatech.pl/technologie/bazy-danych/mysql, [26.04.2020]
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]
Supported Platforms: MySQL Database, https://www.mysql.com/support/supportedplatforms/database.html, [16.10.2020]
S. Juba, A. Volkov, Learning PostgreSQL 11, Packt Publishing, Birmingham, 2019.
S. Riggs, G. Ciolli: PostgreSQL 9 Administration Cookbook, Second Edition, Packt Publishing, Birmingham, 2015.
PostgreSQL Vs. MySQL: Differences In Performance, Syntax, And Features, https://blog.panoply.io/postgresql-vs.-mysql, [26.04.2020]
Article Details
Abstract views: 4287
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
