Currently, the project creates a separate database connection (and closes after execution) for each query defined in dbqueries.py. It would likely be more efficient -- as well as help us test query execution times -- if connections for each data source specified in the .env were set up before any queries were run and then all of them were closed after all queries were run.
Currently, the project creates a separate database connection (and closes after execution) for each query defined in
dbqueries.py
. It would likely be more efficient -- as well as help us test query execution times -- if connections for each data source specified in the.env
were set up before any queries were run and then all of them were closed after all queries were run.