importer: ANALYZE all tables before we are running the export

This should help the query planner to make better decisions when
planning the large queries.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/scripts/location-importer.in b/src/scripts/location-importer.in
index cc66414d579de8013d8ba58352b85e49a58af838..766d8835eccaca032ad6ceb78a6f800d4146c3dd 100644 (file)
--- a/src/scripts/location-importer.in
+++ b/src/scripts/location-importer.in
@@ -336,6 +336,9 @@ class CLI(object):
                if ns.license:
                        writer.license = ns.license
 
+               # Analyze everything for the query planner hopefully making better decisions
+               self.db.execute("ANALYZE")
+
                # Add all Autonomous Systems
                log.info("Writing Autonomous Systems...")