Comparative analysis of query execution speed using Entity Framework for selected database engines

Krzysztof Winiarczyk

krzysztof.r.winiarczyk@gmail.com
Lublin 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, database

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.
  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.
  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.
  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.
  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.
  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

Download


Published
2024-03-20

Cited by

Winiarczyk, K., & Stęgierski, R. (2024). Comparative analysis of query execution speed using Entity Framework for selected database engines. Journal of Computer Sciences Institute, 30, 14–20. https://doi.org/10.35784/jcsi.5278

Authors

Krzysztof Winiarczyk 
krzysztof.r.winiarczyk@gmail.com
Lublin University of Technology Poland

Authors

Rafał Stęgierski 

Lublin University of Technology Poland
https://orcid.org/0000-0001-7225-3275

Statistics

Abstract views: 209
PDF downloads: 214