branch master updated: Reduce the chunk size for querying related derivation ids

[Christopher Baines]

This is an automated email from the git hooks/post-receive script.

cbaines pushed a commit to branch master
in repository data-service.

The following commit(s) were added to refs/heads/master by this push:
     new 77c4e1c  Reduce the chunk size for querying related derivation ids
77c4e1c is described below

commit 77c4e1cb63c4030997f84828af81230040ba2885
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Tue Sep 13 20:58:11 2022 +0100

    Reduce the chunk size for querying related derivation ids
    
    And include the chunk size in the log message.
---
 guix-data-service/model/derivation.scm | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/guix-data-service/model/derivation.scm 
b/guix-data-service/model/derivation.scm
index 5465054..2e0345d 100644
--- a/guix-data-service/model/derivation.scm
+++ b/guix-data-service/model/derivation.scm
@@ -1804,9 +1804,11 @@ WHERE derivation_inputs.derivation_id IN ("
 
                        number))))
              (with-time-logging
-                 "querying for batch of all related derivation ids"
+                 (simple-format
+                  #f "querying for batch of ~A related derivation ids"
+                  (length ids-chunk))
                (exec-query conn query)))))
-        (chunk! ids 2000))
+        (chunk! ids 1000))
        <))
 
     (define (derivation-ids->missing-sources ids)