[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
04/06: Speed up deleting derivation sources
|
From: |
Christopher Baines |
|
Subject: |
04/06: Speed up deleting derivation sources |
|
Date: |
Fri, 21 Jun 2024 07:30:47 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 84a2ad5b25e6e0c69109c7a14a6be13b6bfa3faa
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Thu Jun 20 17:07:41 2024 +0100
Speed up deleting derivation sources
---
guix-data-service/data-deletion.scm | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)
diff --git a/guix-data-service/data-deletion.scm
b/guix-data-service/data-deletion.scm
index 0f64da7..3b6dbd0 100644
--- a/guix-data-service/data-deletion.scm
+++ b/guix-data-service/data-deletion.scm
@@ -435,10 +435,9 @@ DELETE FROM derivation_source_files
WHERE id IN (
SELECT id
FROM derivation_source_files
- WHERE NOT EXISTS (
- SELECT 1
+ WHERE id NOT IN (
+ SELECT derivation_source_file_id
FROM derivation_sources
- WHERE derivation_source_file_id = derivation_source_files.id
)
LIMIT 100
)
- branch master updated (d74422c -> 4e7c2bc), Christopher Baines, 2024/06/21
- 01/06: Reduce max-age for the latest-processed-commit page, Christopher Baines, 2024/06/21
- 03/06: Cache the derivations that weren't deleted, Christopher Baines, 2024/06/21
- 02/06: Speed up select-build-outputs, Christopher Baines, 2024/06/21
- 04/06: Speed up deleting derivation sources,
Christopher Baines <=
- 06/06: Don't compare across systems in one query, Christopher Baines, 2024/06/21
- 05/06: Add a JSON error page, Christopher Baines, 2024/06/21