Publicação
DB Improvements on Code Scalability and Performance
| Resumo: | Emvenci faces escalating requirements and complexity within its application, inevitably leading to performance issues. The database stands out as one of the principal components significantly affected by these challenges. Given the expense of resources, whether human or material, it becomes necessary to seek solutions to address these challenges and preserve the company’s resources. The aim of this project was to improve the database documentation that outlines best practices and create a methodology for performing automated tests to evaluate database performance under different conditions, including possible future scenarios such as high data volume and number of requests during a certain period of time. In this project, these practices were tested using the methodology in a specific use case to assess their impact on database performance. The results demonstrated that while some best practices can improve performance, namely increasing the number of indexes, others can have detrimental effects if applied either as standalone solutions or without a thorough understanding of the use case. With these tests it was also possible to determine the optimal amount of machine resources to perform the use case queries which is 2 CPU and 2 GB of RAM. As a result of these findings, several of these improvements have already been implemented into the Emvenci application. |
|---|---|
| Autores principais: | Rato, João Paulo Rijo das Neves Calcinha |
| Assunto: | Melhoria de desempenho otimização de queries metodologia de testes Trabalhos de projeto de mestrado - 2024 |
| Ano: | 2024 |
| País: | Portugal |
| Tipo de documento: | dissertação de mestrado |
| Tipo de acesso: | acesso restrito |
| Instituição associada: | Universidade de Lisboa |
| Idioma: | inglês |
| Origem: | Repositório da Universidade de Lisboa |
| Resumo: | Emvenci faces escalating requirements and complexity within its application, inevitably leading to performance issues. The database stands out as one of the principal components significantly affected by these challenges. Given the expense of resources, whether human or material, it becomes necessary to seek solutions to address these challenges and preserve the company’s resources. The aim of this project was to improve the database documentation that outlines best practices and create a methodology for performing automated tests to evaluate database performance under different conditions, including possible future scenarios such as high data volume and number of requests during a certain period of time. In this project, these practices were tested using the methodology in a specific use case to assess their impact on database performance. The results demonstrated that while some best practices can improve performance, namely increasing the number of indexes, others can have detrimental effects if applied either as standalone solutions or without a thorough understanding of the use case. With these tests it was also possible to determine the optimal amount of machine resources to perform the use case queries which is 2 CPU and 2 GB of RAM. As a result of these findings, several of these improvements have already been implemented into the Emvenci application. |
|---|