Re: [PATCH] Remove disjunction in pkg_providers query

2018-02-22 Thread Lukas Fleischer
On Wed, 21 Feb 2018 at 15:49:05, Florian Pritz wrote: > For some reason, running the SELECT .. WHERE .. OR .. query takes e.g. > 58ms on a randomly generated db for some dependency name. Splitting the > OR into two dedicated queries and UNIONing the result takes only 0.42ms. > > On the Arch Linux

Re: [PATCH] Remove disjunction in pkg_providers query

2018-02-21 Thread Johannes Löthberg
Quoting Florian Pritz (2018-02-21 15:49:05) > For some reason, running the SELECT .. WHERE .. OR .. query takes e.g. > 58ms on a randomly generated db for some dependency name. Splitting the > OR into two dedicated queries and UNIONing the result takes only 0.42ms. > > On the Arch Linux