search

avniproject / avni-reporting

GNU Affero General Public License v3.0
0 stars 1 forks source link

Little tasks to get reporting perform better #20

Closed vinayvenu closed 4 years ago

vinayvenu commented 4 years ago

This is more of a log of what was done, so that we have a record of it somewhere.

Tasks done

  1. Ensure all production connections from Metabase have sync turned off by default. image.png image.png

  2. Add alerts and create tickets whenever read db CPU goes high. See https://avni.freshdesk.com/a/tickets/783 for an example ticket that is created.

  3. On avni-server, improve performance on views that get created - Change view generation to start using the function get_coded_string_value.

  4. Fix views based on 3 above for Hasiru Dala (KA and TN), JNPCT and MDSR.

  5. Stop working on this for a while since things are much better.

image.png