fedora-infra / bodhi

Bodhi is a web-system that facilitates the process of publishing updates for a Fedora-based software distribution.

https://bodhi.fedoraproject.org

GNU General Public License v2.0

152 stars 194 forks source link

Analyze Bodhi's queries to look for opportunities to add indices #3062

Open bowlofeggs opened 5 years ago

bowlofeggs commented 5 years ago

I recently discovered that Bodhi wasn't indexing a field that seemed like an obvious one to index, so I wrote https://github.com/fedora-infra/bodhi/commit/285c66a00a3391f712f6ef9e55613f497575b7a9

It is likely that there are many other fields that should be indexed but are not. This is likely a fairly easy way to boost Bodhi's performance, essentially for free. We should analyze some of the common queries that Bodhi performs and look for opportunities to speed them up with indices.

bowlofeggs commented 5 years ago

3201 is planned for inclusion in the upcoming 4.0.0 release: #3221. This should help with performance.

bowlofeggs commented 5 years ago

Bodhi 4.0.0 beta is built and deployed to staging:

https://copr.fedorainfracloud.org/coprs/bowlofeggs/bodhi-pre-release https://bodhi.stg.fedoraproject.org/