Skip to content

Query performance improvements by editing the database schema

Lucas Stankus requested to merge 156-query-performance-improvements into master

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.

Merge request reports