The Examination of SQL Queries Efficiency in Chosen IT System
Abstract
Optimization of SQL queries is an important part of any system using a database. Several different optimization methods have been selected and presented in this article, The research was conducted on the MS SQL database engine. The execution times of SQL queries were carefully examined according to defined criteria, then performance optimization was done, followed by repeated tests to obtain results after the optimization. Finally, the results were compared through which conclusions were drawn.
Keywords:
SQL query optimization, databases, testing, performance analysisReferences
G. Dziewit, J. Korczyński, M. Skublewska-Paszkowska, Performance analysis of relational databases Oracle and MS SQL based on desktop application, Journal of Computer Sciences Institute 8 (2018) 263-269, https://doi.org/10.35784/jcsi.693.
DOI: https://doi.org/10.35784/jcsi.693
Google Scholar
M. Woch, Optymalizacja Microsoft SQL server przy współpracy z Microsoft Dynamic NAV, Studia Informatica 28(2) (2007) 17-29.
Google Scholar
E. Noble, Pro T-SQL 2019, Apress, Berkeley, 2020.
DOI: https://doi.org/10.1007/978-1-4842-5590-2
Google Scholar
W. Bolesta, Analysis of query execution speed in the selected NoSQL databases, Journal of Computer Sciences Institute 7 (2018) 138-141, https://doi.org/10.35784/jcsi.662.
DOI: https://doi.org/10.35784/jcsi.662
Google Scholar
Otomoto, https://www.otomoto.pl, [01.11.2022].
Google Scholar
Model MVC, https://vavatech.pl/technologie/architektura/mvc, [01.11.2022].
Google Scholar
SQL - INDEX, https://www.plukasiewicz.net/SQL, [01.11.2022].
Google Scholar
Statistics
Abstract views: 192PDF downloads: 204
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.