Analyze the db at each startup to improve performance

inducer · Dec 28, 2014 · 8d31e4b · 8d31e4b
1 parent 53bb28c
commit 8d31e4b
Showing 1 changed file with 5 additions and 0 deletions.
diff --git a/synoptic/__init__.py b/synoptic/__init__.py
@@ -135,6 +135,10 @@ def __init__(self, sub_app, dburl, exists, echo=False):
         self.sessionmaker = sessionmaker(bind=self.engine, autoflush=True,
                 autocommit=False)
 
+        session = self.sessionmaker()
+        session.execute("analyze;")
+        session.commit()
+
         self.sub_app = sub_app
 
     def __call__(self, environ, start_response):
@@ -340,6 +344,7 @@ def get_json_items(self, session, model, parsed_query, max_timestamp):
 
         last_id = None
         result = []
+
         for row in session.execute(iv_and_t_query):
             if last_id != row[itemversions_query.c.id]:
                 last_id = row[itemversions_query.c.id]