Ways to optimize SQL queries to improve database performance in high–load systems
SQL statements are used to retrieve information from a database. In most cases, these queries are executed very slowly, the reason for this is the low quality of their writing. For better performance, we need to use faster and more efficient queries. This article shows you how to optimize SQL querie...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Igor Sikorsky Kyiv Polytechnic Institute
2021-05-01
|
| Series: | Adaptivni Sistemi Avtomatičnogo Upravlinnâ |
| Subjects: | |
| Online Access: | http://asac.kpi.ua/article/view/226800 |
| _version_ | 1818887366390054912 |
|---|---|
| author | Я. Корнага Ю. Базака Є. Мар’єнко |
| author_facet | Я. Корнага Ю. Базака Є. Мар’єнко |
| author_sort | Я. Корнага |
| collection | DOAJ |
| description | SQL statements are used to retrieve information from a database. In most cases, these queries are executed very slowly, the reason for this is the low quality of their writing. For better performance, we need to use faster and more efficient queries. This article shows you how to optimize SQL queries for better performance. The topic of query optimization is very broad, but we will try to cover the most important aspects of this issue. In this paper, I do not focus on in–depth database analysis, but focus on simple hints and tips for setting up queries that can be used to immediately increase productivity.
Ref. 6, pic. 5 |
| first_indexed | 2024-12-19T16:36:05Z |
| format | Article |
| id | doaj.art-db793f2caada478c9c7bd22c854be7f4 |
| institution | Directory Open Access Journal |
| issn | 1560-8956 2522-9575 |
| language | English |
| last_indexed | 2024-12-19T16:36:05Z |
| publishDate | 2021-05-01 |
| publisher | Igor Sikorsky Kyiv Polytechnic Institute |
| record_format | Article |
| series | Adaptivni Sistemi Avtomatičnogo Upravlinnâ |
| spelling | doaj.art-db793f2caada478c9c7bd22c854be7f42022-12-21T20:13:57ZengIgor Sikorsky Kyiv Polytechnic InstituteAdaptivni Sistemi Avtomatičnogo Upravlinnâ1560-89562522-95752021-05-0123710.20535/1560-8956.37.2020.226800Ways to optimize SQL queries to improve database performance in high–load systemsЯ. Корнага0Ю. Базака1Є. Мар’єнко2National technical university of Ukraine "Igor Sikorsky Kyiv polytechnic institute"National technical university of Ukraine "Igor Sikorsky Kyiv polytechnic institute"National technical university of Ukraine "Igor Sikorsky Kyiv polytechnic institute"SQL statements are used to retrieve information from a database. In most cases, these queries are executed very slowly, the reason for this is the low quality of their writing. For better performance, we need to use faster and more efficient queries. This article shows you how to optimize SQL queries for better performance. The topic of query optimization is very broad, but we will try to cover the most important aspects of this issue. In this paper, I do not focus on in–depth database analysis, but focus on simple hints and tips for setting up queries that can be used to immediately increase productivity. Ref. 6, pic. 5http://asac.kpi.ua/article/view/226800SQLoptimizationdatabasequeryperformanceanalysis |
| spellingShingle | Я. Корнага Ю. Базака Є. Мар’єнко Ways to optimize SQL queries to improve database performance in high–load systems Adaptivni Sistemi Avtomatičnogo Upravlinnâ SQL optimization database query performance analysis |
| title | Ways to optimize SQL queries to improve database performance in high–load systems |
| title_full | Ways to optimize SQL queries to improve database performance in high–load systems |
| title_fullStr | Ways to optimize SQL queries to improve database performance in high–load systems |
| title_full_unstemmed | Ways to optimize SQL queries to improve database performance in high–load systems |
| title_short | Ways to optimize SQL queries to improve database performance in high–load systems |
| title_sort | ways to optimize sql queries to improve database performance in high load systems |
| topic | SQL optimization database query performance analysis |
| url | http://asac.kpi.ua/article/view/226800 |
| work_keys_str_mv | AT âkornaga waystooptimizesqlqueriestoimprovedatabaseperformanceinhighloadsystems AT ûbazaka waystooptimizesqlqueriestoimprovedatabaseperformanceinhighloadsystems AT êmarênko waystooptimizesqlqueriestoimprovedatabaseperformanceinhighloadsystems |