Re: Towards faster keyword searches

> On Sep 25, 2016, at 23:51, Jeff Fearn <[email protected]> wrote:
>=20
>> There are a whole class of these -- anything that is a 'multiselect' typ=
e 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.
>=20
> The effect of using ID lists instead of sub selects is wider than just
> searching, as the above patch demonstrates.
>=20
Noted :-)


>=20
> 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:
<https://lists.bugzilla.org/cgi-bin/mj_wwwusr?user=3Dgcbd-developers-Uylq5CNFT+jYtjvyW6yDsg@public.gmane.org>