[PATCH] Remove disjunction in pkg_providers query

Lukas Fleischer lfleischer at archlinux.org
Fri Feb 23 05:43:33 UTC 2018


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 <bluewind at xinu.at>
> ---
>  web/lib/pkgfuncs.inc.php | 6 ++++--
>  1 file changed, 4 insertions(+), 2 deletions(-)

Merged, thanks.


More information about the aur-dev mailing list