Analysis of the optimization of SQL statements of the Structured Query Language using large volumes of data

Abstract:

This work examines the importance of the optimization of statements of the Structured Query Language (SQL) under the condition of operating with millions of data records. It is intended to elucidate whether a single optimization stage is enough when changing the volume of data. For this purpose, the structure of a real and in-service database was used, which was populated with one and five million records. Then, complex queries were raised to be resolved by the script that contained SELECT statements and measure the response time of their execution. After optimizing the sentences twice, it was found that it is possible to reduce the response time in t/10 seconds. These results confirm that complex SQL statements must be optimized according to the database manager where they are run for the different ranges of millions of records.

Año de publicación:

2018

Keywords:

Fuente:

google