From 77beb5949511db7fc5236567b8b1d25d98f82bbb Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Tue, 4 Feb 2020 00:11:47 +0000 Subject: Use a temporary table when inserting package metadata entries To speed up this step, as there is a lot of data. --- guix-data-service/model/package-metadata.scm | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/guix-data-service/model/package-metadata.scm b/guix-data-service/model/package-metadata.scm index 87a5dba..e2166d5 100644 --- a/guix-data-service/model/package-metadata.scm +++ b/guix-data-service/model/package-metadata.scm @@ -179,4 +179,7 @@ WHERE packages.id IN ( ;; you have one package definition which interits from another, and just ;; overrides the version and the source, the package_metadata entries for ;; both definitions will be the same. - #:delete-duplicates? #t)) + #:delete-duplicates? #t + ;; There is so much package metadata that it's worth creating a temporary + ;; table + #:use-temporary-table? #t)) -- cgit v1.2.3