From:  Dylan Hardison <>
Date:  26 Sep 2016 12:05:13 Hong Kong Time

Re: Towards faster keyword searches


> On Sep 25, 2016, at 23:51, Jeff Fearn  wrote:
>> There are a whole class of these -- anything that is a 'multiselect' type search. I believe someone suggested embedding these queries (at least as an option)
>> as a sub select and in general I think that's a good idea. An even nicer idea is to just let elastic search do the searching.
>> One of these approaches I hope to explore with an outreachy intern.
> The effect of using ID lists instead of sub selects is wider than just
> searching, as the above patch demonstrates.
Noted :-)

> I ran this on a copy of our DB and it seems to perform well. I did have
> to chop off the order by as it's not leagl in Pg to have a group by
> clause and then order by things not in the group by clause or an
> aggregate function.

I would hope that offending code is only generated by the (mysql) parts of Bugzilla::DB::*. I'll verify that before getting that ready for review.-
To view or change your list settings, click here: