204535 - implement product/status combined index for performance

Status: NEW

(Bugzilla :: Bugzilla-General, defect)

Description

[Myk Melez [:myk] [@mykmelez]]

Many Bugzilla searches limit both product and status, but MySQL can only use one
index per table per query, so it has to choose between indexes for those two
columns.  We should implement a combined product/status index so MySQL can use
it when a user submits a query with both product and status criteria.

Comment 1

[Dave Miller [:justdave]]

Reassigning bugs that I'm not actively working on to the default component owner
in order to try to make some sanity out of my personal buglist.  This doesn't
mean the bug isn't being dealt with, just that I'm not the one doing it.  If you
are dealing with this bug, please assign it to yourself.