[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
05/05: Remove redundant DISTINCT from the derivation range INSERT query
From: |
Christopher Baines |
Subject: |
05/05: Remove redundant DISTINCT from the derivation range INSERT query |
Date: |
Wed, 25 Mar 2020 04:14:51 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 60df7ecbf92ea57e3cf3b694459944a5d5fa682f
Author: Christopher Baines <address@hidden>
AuthorDate: Tue Mar 24 21:37:18 2020 +0000
Remove redundant DISTINCT from the derivation range INSERT query
This was redundant and slow, so don't do it.
---
.../model/package-derivation-by-guix-revision-range.scm | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git
a/guix-data-service/model/package-derivation-by-guix-revision-range.scm
b/guix-data-service/model/package-derivation-by-guix-revision-range.scm
index 712f546..4c5cbf6 100644
--- a/guix-data-service/model/package-derivation-by-guix-revision-range.scm
+++ b/guix-data-service/model/package-derivation-by-guix-revision-range.scm
@@ -66,11 +66,11 @@ SELECT DISTINCT
OVER package_version AS last_guix_revision_id
FROM packages
INNER JOIN (
- SELECT DISTINCT package_derivations.package_id,
- package_derivations.derivation_id,
- package_derivations.system,
- package_derivations.target,
- guix_revision_package_derivations.revision_id
+ SELECT package_derivations.package_id,
+ package_derivations.derivation_id,
+ package_derivations.system,
+ package_derivations.target,
+ guix_revision_package_derivations.revision_id
FROM package_derivations
INNER JOIN guix_revision_package_derivations
ON package_derivations.id =
guix_revision_package_derivations.package_derivation_id