Comparative analysis of query execution speed using Entity Framework for selected database engines
Krzysztof Winiarczyk
krzysztof.r.winiarczyk@gmail.comLublin University of Technology (Poland)
Rafał Stęgierski
Lublin University of Technology (Poland)
https://orcid.org/0000-0001-7225-3275
Abstract
This article presents the comparative analysis of time efficiency while executing queries by object-relational mapping framework Entity Framework for the following database engines: Microsoft SQL Server, MySQL and PostgreSQL. Time measurements of obtaining object results from database queries were made by app created in C#. Queries referred to single or multiple tables linked by relationships (1:1, 1:n, m:n) and performed operations of reading, creating, updating and deleting data. Obtained results have been cleaned from outliers and trimmed means were given as final results. Different database engines obtained the shortest query execution times depending on record number and table structures.
Keywords:
time efficiency, Entity Framework, databaseReferences
S. Cvetković, D. Janković, A Comparative Study of the Features and Performance of ORM Tools in a .NET Environment, Objects and Databases, Lecture Notes in Computer Science 6348 (2010) 147-158 https://doi.org/10.1007/978-3-642-16092-9_14.
DOI: https://doi.org/10.1007/978-3-642-16092-9_14
Google Scholar
D. Zmaranda, L. Pop-Fele, C. Gyorödi, R. Gyorödi, G. Pecherle, Performance comparison of CRUD methods using NET object relational mappers: A case study, International Journal of Advanced Computer Science and Applications 11(1) (2020) 55-65, https://dx.doi.org/10.14569/ijacsa.2020.0110107.
DOI: https://doi.org/10.14569/IJACSA.2020.0110107
Google Scholar
C.A. Győrödi, D.V. Dumşe-Burescu, D.R. Zmaranda, R.Ş. Győrödi, G.A. Gabor, G.D. Pecherle, Performance analysis of nosql and relational databases with couchdb and mysql for application’s data storage, Applied Sciences (Switzerland) 10(23) (2020) 1-21 https://dx.doi.org/10.3390/app10238524.
DOI: https://doi.org/10.3390/app10238524
Google Scholar
T. Seser, V. Plestina, F. Marjanica, Performance analysis of SQL prepared statements in CRUD operations. 7th International Conference on Smart and Sustainable Technologies, SpliTech (2022), https://dx.doi.org/10.23919/SpliTech55088.2022.9854303.
DOI: https://doi.org/10.23919/SpliTech55088.2022.9854303
Google Scholar
A. Gruca, P. Podsiadło, Performance Analysis of .NET Based Object–Relational Mapping Frameworks, Beyond Databases, Architectures and Structures, Communications in Computer and Information Science 424 (2014) 40-49, https://dx.doi.org/10.1007/978-3-319-06932-6_5.
DOI: https://doi.org/10.1007/978-3-319-06932-6_5
Google Scholar
A tour of the C# language, https://learn.microsoft.com /en-us/dotnet/csharp/tour-of-csharp/, [17.06.2023]
Google Scholar
What is .NET? Introduction and overview, https://learn. microsoft.com/en-us/dotnet/core/introduction, [17.06.2023]
Google Scholar
Entity Framework Core, https://learn.microsoft.com/en-us/ef/core/, [17.06.2023]
Google Scholar
Microsoft SQL Server 2022 Licensing guide, https://download.microsoft.com/download/9/3/d/93d32de6-f268-45ed-ba25-2f9a6756b6af/SQL_Server_2022_Licensing_guide.pdf, [17.06.2023]
Google Scholar
What is MySQL?, https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html, [17.06.2023]
Google Scholar
PostgreSQL about https://www.postgresql.org/about/, [17.06.2023]
Google Scholar
Authors
Krzysztof Winiarczykkrzysztof.r.winiarczyk@gmail.com
Lublin University of Technology Poland
Authors
Rafał StęgierskiLublin University of Technology Poland
https://orcid.org/0000-0001-7225-3275
Statistics
Abstract views: 236PDF downloads: 246
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
