unofficial mirror of bug-guix@gnu.org 
 help / color / mirror / 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

unofficial mirror of bug-guix@gnu.org 

This inbox may be cloned and mirrored by anyone:

	git clone --mirror https://yhetil.org/guix-bugs/0 guix-bugs/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 guix-bugs guix-bugs/ https://yhetil.org/guix-bugs \
		bug-guix@gnu.org
	public-inbox-index guix-bugs

Example config snippet for mirrors.
Newsgroups are available over NNTP:
	nntp://news.yhetil.org/yhetil.gnu.guix.bugs
	nntp://news.gmane.io/gmane.comp.gnu.guix.bugs


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git