pool_recycle 3600

1 files changed, 2 insertions, 2 deletions

diff --git a/megapixels/app/models/sql_factory.py b/megapixels/app/models/sql_factory.py
index da95b539..b270afd2 100644
--- a/megapixels/app/models/sql_factory.py
+++ b/megapixels/app/models/sql_factory.py
@@ -35,7 +35,7 @@ def load_sql_datasets(replace=False, base_model=None):
   global datasets, loaded, Session
   if loaded:
     return datasets
-  engine = create_engine(connection_url, encoding="utf-8")
+  engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600)
   # db.set_character_set('utf8')
   # dbc = db.cursor()
   # dbc.execute('SET NAMES utf8;')
@@ -76,7 +76,7 @@ class SqlDataset:
     self.name = name
     self.tables = {}
     if base_model is None:
-      self.engine = create_engine(connection_url)
+      self.engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600)
       base_model = declarative_base(engine)
     self.base_model = base_model