Query performance improvements by editing the database schema
This is the first of a series of MRs related to allowing HealthDashboard/InternaSUS to support SIH datasets from all regions of Brazil. This last of them will add a new and public dataset to the repository containing procedures from the state of Rio de Janeiro from 2019 to 2020.
This in particular focuses on two main performance improvements:
- turning the population data into a table and using SQL to retrieve the data.
- compressing an iteration over all facilities into a single SQL query.