cbaines pushed a commit to branch master
in repository data-service.
commit 84a2ad5b25e6e0c69109c7a14a6be13b6bfa3faa
Author: Christopher Baines <[email protected]>
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
)
