koji

#1675 Subselect gives better performance
Merged by tkopecek. Opened by tkopecek.
tkopecek/koji issue1671  into  master

Download 1675.patch

Original query based on JOINs is 1000x slower in better cases. Sub-query
helps a lot here.

Fixes: https://pagure.io/koji/issue/1674

@breilly @julian8628 @mikem

rpminfo.buildroot_id could be NULL. Will it break something?

rpminfo.buildroot_id could be NULL. Will it break something?

I don't think so - even in original query it will be omitted. And we don't care about rpms not used in buildroots here.

:thumbsup:

:thumbsup:

Commit c4a6f7da fixes this pull-request

Pull-Request has been merged by tkopecek
Metadata
None
No Tags
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.