diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-03-13 23:34:56 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-03-14 12:35:34 +0000 |
| commit | 6e81acf0a5c0b75c3f491d875753ae4231aac55d (patch) | |
| tree | 0a146b4f0c71881606c5386e6c6db2e69fbe2543 | |
| parent | baeae56de4f7acae5c7e4fe475ba97b2695ad2f8 (diff) | |
| download | data-service-6e81acf0a5c0b75c3f491d875753ae4231aac55d.tar data-service-6e81acf0a5c0b75c3f491d875753ae4231aac55d.tar.gz | |
Set an order for select-outputs-without-known-nar-entries
Pulling out the recent entries first.
| -rw-r--r-- | guix-data-service/model/nar.scm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/guix-data-service/model/nar.scm b/guix-data-service/model/nar.scm index 4c5d070..ff6a5d5 100644 --- a/guix-data-service/model/nar.scm +++ b/guix-data-service/model/nar.scm @@ -305,7 +305,7 @@ ORDER BY COUNT(*) DESC") (define query (string-append " -SELECT DISTINCT derivation_output_details.path +SELECT DISTINCT derivation_output_details.path, derivation_output_details.id FROM derivations INNER JOIN derivation_outputs ON derivations.id = derivation_outputs.derivation_id @@ -346,6 +346,7 @@ WHERE derivation_output_details.path NOT IN ( ") )")) " +ORDER BY derivation_output_details.id DESC LIMIT 10000")) (map car (exec-query conn query (list (number->string build-server-id))))) |