From unknown Sun Jun 22 00:54:23 2025 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 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 unknown Sun Jun 22 00:54:23 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: Mathieu Othacehe Subject: bug#43826: closed (Re: bug#43826: cuirass: build query is too slow.) Message-ID: References: <87r1qai78d.fsf@gnu.org> <87h7r734jj.fsf@gnu.org> X-Gnu-PR-Message: they-closed 43826 X-Gnu-PR-Package: guix Reply-To: 43826@debbugs.gnu.org Date: Wed, 07 Oct 2020 11:53:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1602071582-26939-1" This is a multi-part message in MIME format... ------------=_1602071582-26939-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #43826: cuirass: build query is too slow. which was filed against the guix package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 43826@debbugs.gnu.org. --=20 43826: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D43826 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1602071582-26939-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit 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 ------------=_1602071582-26939-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit 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 ------------=_1602071582-26939-1--