koji

#3448 Default ordering is suboptimal
Closed: Fixed by tkopecek. Opened by tkopecek.

Closed: Fixed
Reopen Issue

E.g. when searching for rpm name, default ordering is id DESC. It results in full scan. It is not used that often but when is it is taking years. Let's check if we can improve these searches by appropriate indices. E.g. for rpm:

CREATE INDEX rpminfo_filename_id ON rpminfo((name || '-' || version || '-' || release || '.' || arch || '.rpm'), id);

Most other searches span more tables so simle indices are not possible.
PR #3453

Metadata Update from @tkopecek:
- Custom field Size adjusted to None

Metadata Update from @tkopecek:
- Issue tagged with: testing-ready

Metadata Update from @relias-redhat:
- Issue tagged with: testing-done

Commit c2f9cc65 fixes this issue

Commit e461659a relates to this ticket

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/3448

Please continue any further discussion there.
Metadata
None

testing-done testing-ready

None
None
Low
None
Related Pull Requests
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.