diff options
| author | Florian Pritz <bluewind@xinu.at> | 2018-02-21 15:49:05 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2018-02-24 14:57:31 +0100 |
| commit | f51d4c32cd8bed69d2f6b0c50424280613c68496 (patch) | |
| tree | eeece4750080f1cb269809ce27826aa8e34273b4 /web/lib/acctfuncs.inc.php | |
| parent | 34a0d399103a3b866995e54f03ac75740fdd26a0 (diff) | |
| download | aur-f51d4c32cd8bed69d2f6b0c50424280613c68496.tar.gz aur-f51d4c32cd8bed69d2f6b0c50424280613c68496.tar.xz | |
Remove disjunction in pkg_providers query
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@xinu.at>
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'web/lib/acctfuncs.inc.php')
0 files changed, 0 insertions, 0 deletions