From unknown Sat Jun 21 10:38:41 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#43826 <43826@debbugs.gnu.org> To: bug#43826 <43826@debbugs.gnu.org> Subject: Status: cuirass: build query is too slow. Reply-To: bug#43826 <43826@debbugs.gnu.org> Date: Sat, 21 Jun 2025 17:38:41 +0000 retitle 43826 cuirass: build query is too slow. reassign 43826 guix submitter 43826 Mathieu Othacehe severity 43826 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Tue Oct 06 08:47:08 2020 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 To: bug-guix@gnu.org Subject: cuirass: build query is too slow. 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-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) 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 From debbugs-submit-bounces@debbugs.gnu.org Wed Oct 07 07:52:11 2020 Received: (at 43826-done) by debbugs.gnu.org; 7 Oct 2020 11:52:11 +0000 Received: from localhost ([127.0.0.1]:55479 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kQ7zP-0006zN-41 for submit@debbugs.gnu.org; Wed, 07 Oct 2020 07:52:11 -0400 Received: from eggs.gnu.org ([209.51.188.92]:55730) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kQ7zN-0006zC-O0 for 43826-done@debbugs.gnu.org; Wed, 07 Oct 2020 07:52:10 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:43431) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kQ7zI-00012o-DB for 43826-done@debbugs.gnu.org; Wed, 07 Oct 2020 07:52:04 -0400 Received: from [2a01:e0a:19b:d9a0:4192:d6b6:52f:260e] (port=48572 helo=cervin) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1kQ7zH-000821-V6 for 43826-done@debbugs.gnu.org; Wed, 07 Oct 2020 07:52:04 -0400 From: Mathieu Othacehe To: 43826-done@debbugs.gnu.org Subject: Re: bug#43826: cuirass: build query is too slow. References: <87h7r734jj.fsf@gnu.org> Date: Wed, 07 Oct 2020 13:52:02 +0200 In-Reply-To: <87h7r734jj.fsf@gnu.org> (Mathieu Othacehe's message of "Tue, 06 Oct 2020 14:46:56 +0200") Message-ID: <87r1qai78d.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-Debbugs-Envelope-To: 43826-done X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) > 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. Fixed with cb2c4e3d8f7eda187adf6da1fc35aef838c49828. Mathieu From unknown Sat Jun 21 10:38:41 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Wed, 04 Nov 2020 12:24:06 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator