[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