diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-05-23 00:42:10 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-05-23 00:48:25 +0200 |
| commit | 1720b0586cfe0b4e0b32fd8b3ca5b9ef1799d2bc (patch) | |
| tree | a71ba2025ea206bb0216d418b808edbe7b48fc1c /data/sql | |
| parent | bfa170c032c9d0a394197c4e25c4b15bda60087b (diff) | |
| download | PROJ-1720b0586cfe0b4e0b32fd8b3ca5b9ef1799d2bc.tar.gz PROJ-1720b0586cfe0b4e0b32fd8b3ca5b9ef1799d2bc.zip | |
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.
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/commit.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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; |