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

Previous Next

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>
Cc: tracker <at> debbugs.gnu.org
Subject: bug#43826: closed (cuirass: build query is too slow.)
Date: Wed, 07 Oct 2020 11:53:02 +0000

[Message part 1 (text/plain, inline)]

Your message dated Wed, 07 Oct 2020 13:52:02 +0200
with message-id <87r1qai78d.fsf <at> gnu.org>
and subject line Re: bug#43826: cuirass: build query is too slow.
has caused the debbugs.gnu.org bug report #43826,
regarding cuirass: build query is too slow.
to be marked as done.

(If you believe you have received this mail in error, please contact
help-debbugs <at> 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: 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

[Message part 3 (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

Previous Next

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