From 1720b0586cfe0b4e0b32fd8b3ca5b9ef1799d2bc Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Sun, 23 May 2021 00:42:10 +0200 Subject: Database: add a ANALYZE step during proj.db creation This will create the sqlite_stat* table (generally sqlite_stat1). This speeds up a bit the test suite. Runtime of ``make test_cpp_api-check`` goes from the range [14.0 s, 14.6 s] to [13.0s, 13.5s] on my machine. --- data/sql/commit.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'data/sql/commit.sql') diff --git a/data/sql/commit.sql b/data/sql/commit.sql index e5850211..dbf1d738 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -301,4 +301,6 @@ INSERT INTO dummy DEFAULT VALUES; DROP TRIGGER final_checks; DROP TABLE dummy; +ANALYZE; + VACUUM; -- cgit v1.2.3