Use database views to improve performance

edgi-govdata-archiving / ECHO-Cross-Program

Jupyter Notebooks for ECHO that use data from multiple EPA programs

https://colab.research.google.com/github/edgi-govdata-archiving/ECHO-Cross-Program/blob/master/ECHO-Cross-Programs.ipynb

GNU General Public License v3.0

8 stars 5 forks source link

Use database views to improve performance #62

Closed shansen5 closed 3 years ago

shansen5 commented 3 years ago

Database views have been added that permit retrieving facility information from ECHO_EXPORTER and program-specific data from the various data source tables at the same time. Change the notebook, DataSet class and utilities.py functions to work with these views.

ericnost commented 3 years ago

I think we can close this @shansen5 ?