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
?