all messages for Guix-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* bug#43826: cuirass: build query is too slow.
@ 2020-10-06 12:46 Mathieu Othacehe
  2020-10-07 11:52 ` Mathieu Othacehe
  0 siblings, 1 reply; 2+ messages in thread
From: Mathieu Othacehe @ 2020-10-06 12:46 UTC (permalink / raw)
  To: 43826


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




^ permalink raw reply	[flat|nested] 2+ messages in thread

* bug#43826: cuirass: build query is too slow.
  2020-10-06 12:46 bug#43826: cuirass: build query is too slow Mathieu Othacehe
@ 2020-10-07 11:52 ` Mathieu Othacehe
  0 siblings, 0 replies; 2+ messages in thread
From: Mathieu Othacehe @ 2020-10-07 11:52 UTC (permalink / raw)
  To: 43826-done


> 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




^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2020-10-07 11:55 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2020-10-06 12:46 bug#43826: cuirass: build query is too slow Mathieu Othacehe
2020-10-07 11:52 ` Mathieu Othacehe

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/guix.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.