#3448 Default ordering is suboptimal
Closed: Fixed a year ago by tkopecek. Opened 2 years ago by tkopecek.

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

2 years ago

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

2 years ago

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

a year ago

Commit e461659 relates to this ticket

Login to comment on this ticket.

Metadata
Related Pull Requests
  • #3453 Merged a year ago