Comparative analysis of query execution speed using Entity Framework for selected database engines
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...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Lublin University of Technology
2024-03-01
|
| Series: | Journal of Computer Sciences Institute |
| Subjects: | |
| Online Access: | https://ph.pollub.pl/index.php/jcsi/article/view/5278 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832570019751395328 |
|---|---|
| author | Krzysztof Winiarczyk Rafał Stęgierski |
| author_facet | Krzysztof Winiarczyk Rafał Stęgierski |
| author_sort | Krzysztof Winiarczyk |
| collection | DOAJ |
| description |
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.
|
| format | Article |
| id | doaj-art-a1baf0f5dfd14cb5be8ce20f852695e8 |
| institution | Kabale University |
| issn | 2544-0764 |
| language | English |
| publishDate | 2024-03-01 |
| publisher | Lublin University of Technology |
| record_format | Article |
| series | Journal of Computer Sciences Institute |
| spelling | doaj-art-a1baf0f5dfd14cb5be8ce20f852695e82025-02-02T18:02:58ZengLublin University of TechnologyJournal of Computer Sciences Institute2544-07642024-03-013010.35784/jcsi.5278Comparative analysis of query execution speed using Entity Framework for selected database enginesKrzysztof Winiarczyk0Rafał Stęgierski1https://orcid.org/0000-0001-7225-3275Lublin University of TechnologyLublin University of Technology 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. https://ph.pollub.pl/index.php/jcsi/article/view/5278time efficiencyEntity Frameworkdatabase |
| spellingShingle | Krzysztof Winiarczyk Rafał Stęgierski Comparative analysis of query execution speed using Entity Framework for selected database engines Journal of Computer Sciences Institute time efficiency Entity Framework database |
| title | Comparative analysis of query execution speed using Entity Framework for selected database engines |
| title_full | Comparative analysis of query execution speed using Entity Framework for selected database engines |
| title_fullStr | Comparative analysis of query execution speed using Entity Framework for selected database engines |
| title_full_unstemmed | Comparative analysis of query execution speed using Entity Framework for selected database engines |
| title_short | Comparative analysis of query execution speed using Entity Framework for selected database engines |
| title_sort | comparative analysis of query execution speed using entity framework for selected database engines |
| topic | time efficiency Entity Framework database |
| url | https://ph.pollub.pl/index.php/jcsi/article/view/5278 |
| work_keys_str_mv | AT krzysztofwiniarczyk comparativeanalysisofqueryexecutionspeedusingentityframeworkforselecteddatabaseengines AT rafałstegierski comparativeanalysisofqueryexecutionspeedusingentityframeworkforselecteddatabaseengines |