GNU bug report logs - #43826
cuirass: build query is too slow.

Previous Next

Package: guix;

Reported by: Mathieu Othacehe <othacehe <at> gnu.org>

Date: Tue, 6 Oct 2020 12:48:02 UTC

Severity: normal

Done: Mathieu Othacehe <othacehe <at> gnu.org>

Bug is archived. No further changes may be made.

Full log


View this message in rfc822 format

From: help-debbugs <at> gnu.org (GNU bug Tracking System)
To: Mathieu Othacehe <othacehe <at> gnu.org>
Subject: bug#43826: closed (Re: bug#43826: cuirass: build query is too slow.)
Date: Wed, 07 Oct 2020 11:53:02 +0000
[Message part 1 (text/plain, inline)]
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 <at> debbugs.gnu.org.

-- 
43826: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=43826
GNU Bug Tracking System
Contact help-debbugs <at> gnu.org with problems
[Message part 2 (message/rfc822, inline)]
From: Mathieu Othacehe <othacehe <at> gnu.org>
To: 43826-done <at> debbugs.gnu.org
Subject: Re: bug#43826: cuirass: build query is too slow.
Date: Wed, 07 Oct 2020 13:52:02 +0200
> 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

[Message part 3 (message/rfc822, inline)]
From: Mathieu Othacehe <othacehe <at> gnu.org>
To: bug-guix <at> gnu.org
Subject: cuirass: build query is too slow.
Date: Tue, 06 Oct 2020 14:46:56 +0200
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



This bug report was last modified 4 years and 229 days ago.

Previous Next


GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.