Subject: bug#43826: closed (Re: bug#43826: cuirass: build query is too slow.)

From: [email-masked] (GNU bug Tracking System)
Date: Wed, 07 Oct 2020 11:53:02 +0000

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 [email-masked].

-- 
43826: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=43826
GNU Bug Tracking System
Contact [email-masked] with problems

Subject: Re: bug#43826: cuirass: build query is too slow.
From: Mathieu Othacehe <[email-masked]>
To: [email-masked]
Date: Wed, 07 Oct 2020 13:52:02 +0200
List-Id: <debbugs-submit.debbugs.gnu.org>

> 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

Subject: cuirass: build query is too slow.
From: Mathieu Othacehe <[email-masked]>
To: [email-masked]
Date: Tue, 06 Oct 2020 14:46:56 +0200
List-Id: <debbugs-submit.debbugs.gnu.org>

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