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 installation, searching for the providers of e.g. > mongodb takes >=110ms when not cached by the query cache. The new query > takes <1ms even when not cached. > > Signed-off-by: Florian Pritz <bluew...@xinu.at> > --- > web/lib/pkgfuncs.inc.php | 6 ++++-- > 1 file changed, 4 insertions(+), 2 deletions(-)
Merged, thanks.