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

Main Article Content

DOI

Krzysztof Winiarczyk

krzysztof.r.winiarczyk@gmail.com

Rafał Stęgierski

r.stegierski@pollub.pl

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

References

Article Details

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