From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id Kkc9O/RnfF8fYQAA0tVLHw (envelope-from ) for ; Tue, 06 Oct 2020 12:49:56 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id O/PANvRnfF+RdgAAB5/wlQ (envelope-from ) for ; Tue, 06 Oct 2020 12:49:56 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 8A6DC9401DE for ; Tue, 6 Oct 2020 12:49:56 +0000 (UTC) Received: from localhost ([::1]:41530 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kPmPi-0003mZ-Bk for larch@yhetil.org; Tue, 06 Oct 2020 08:49:54 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58116) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kPmNv-00023t-U7 for bug-guix@gnu.org; Tue, 06 Oct 2020 08:48:03 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:40385) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kPmNv-0000fn-21 for bug-guix@gnu.org; Tue, 06 Oct 2020 08:48:03 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1kPmNu-0007uJ-Kd for bug-guix@gnu.org; Tue, 06 Oct 2020 08:48:02 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#43826: cuirass: build query is too slow. Resent-From: Mathieu Othacehe Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 06 Oct 2020 12:48:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 43826 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: 43826@debbugs.gnu.org X-Debbugs-Original-To: bug-guix@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.160198842830334 (code B ref -1); Tue, 06 Oct 2020 12:48:02 +0000 Received: (at submit) by debbugs.gnu.org; 6 Oct 2020 12:47:08 +0000 Received: from localhost ([127.0.0.1]:51931 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kPmN2-0007tB-8t for submit@debbugs.gnu.org; Tue, 06 Oct 2020 08:47:08 -0400 Received: from lists.gnu.org ([209.51.188.17]:52128) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kPmN0-0007t4-W8 for submit@debbugs.gnu.org; Tue, 06 Oct 2020 08:47:07 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:57872) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kPmN0-000157-M1 for bug-guix@gnu.org; Tue, 06 Oct 2020 08:47:06 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:50818) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kPmN0-0000ai-BP for bug-guix@gnu.org; Tue, 06 Oct 2020 08:47:06 -0400 Received: from [2a01:e0a:19b:d9a0:4192:d6b6:52f:260e] (port=36442 helo=cervin) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1kPmMs-0002pt-0X for bug-guix@gnu.org; Tue, 06 Oct 2020 08:47:05 -0400 From: Mathieu Othacehe Date: Tue, 06 Oct 2020 14:46:56 +0200 Message-ID: <87h7r734jj.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -3.3 (---) X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: "bug-Guix" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Spam-Score: -1.51 X-TUID: kyR7lgKkwJhS Hello, When "db-get-builds" is called with a limit set to N, at least ~2N queries are executed. First the main query returns the build list, then build outputs and build products are searched. All of this should be combined in a unique query to minimize overhead. The limit should also by restricted to at most 1000 builds for instance. Thanks, Mathieu