cuirass: build query is too slow.

  • Done
  • quality assurance status badge
Details
One participant
  • Mathieu Othacehe
Owner
unassigned
Submitted by
Mathieu Othacehe
Severity
normal
M
M
Mathieu Othacehe wrote on 6 Oct 2020 14:46
(address . bug-guix@gnu.org)
87h7r734jj.fsf@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
M
M
Mathieu Othacehe wrote on 7 Oct 2020 13:52
(address . 43826-done@debbugs.gnu.org)
87r1qai78d.fsf@gnu.org
Toggle quote (4 lines)
> 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
Closed
?
Your comment

This issue is archived.

To comment on this conversation send an email to 43826@debbugs.gnu.org

To respond to this issue using the mumi CLI, first switch to it
mumi current 43826
Then, you may apply the latest patchset in this issue (with sign off)
mumi am -- -s
Or, compose a reply to this issue
mumi compose
Or, send patches to this issue
mumi send-email *.patch