Comparativo de desempenho de consultas SQL entre banco de dados em memória RAM e em SSD

Abstract

The main objective of this work was to compare performance of SQL queries in two new technologies that are about to come out in relation to the traditional model, which are the Inmemory Database and the Disk Database Solids (SSD). To simulate these queries, identical databases were created for each technology, these banks simulated sales control by product and customer. In these scenarios queries were executed that return a large amount of results with sales data of several months, which in the traditional scenario using Hard Disk can take a few minutes. The same query was performed in the other two environments, where the performance of these queries was measured and at the end it was verified that the best alternative was the Inmemory for a smaller volume of information and the SSD for a larger volume of data.