Relational Database Performance Comparation

This paper discusses the performance of different relational databases using query analysis and optimization under different conditions. The three most popular relational databases are PostgreSQL, MySQL and MS SQL. The basic query execution time for different numbers of operators, columns, and rows was taken as the main criterion. As a result of experiments, it was determined that all databases with small amounts of stored information in the basic configuration operate in accordance with the declared performance. However, with small amounts of data, PostgreSQL is the most preferred option for use, since it is the fastest to process information. It has also been proven that MS SQL has the largest rate increment when increasing the number of columns from all databases under investigation.