From:  Dylan Hardison <dylan@mozilla.com>
Date:  26 Sep 2016 12:05:13 Hong Kong Time
Newsgroup:  news.mozilla.org/mozilla.dev.apps.bugzilla
Subject:  

Re: Towards faster keyword searches

NNTP-Posting-Host:  63.245.214.181

> 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: