summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-10-07 12:02:55 +0200
committerYorhel <git@yorhel.nl>2019-10-07 12:10:02 +0200
commitbf734c442f14d32a166034ebc076c84b52b07840 (patch)
tree1707c6ff571ce3c44eb8edd6e4118041cdd27ae9 /lib
parent4844a42cb554253340391fdbdc5a7634ee287b1e (diff)
SQL: Improve performance of update_vnpopularity()
Goes from 1.5 minutes to 1.5 seconds. Temporary views instead of CTEs and self-joins instead of window functions. That code was *old*.
Diffstat (limited to 'lib')
0 files changed, 0 insertions, 0 deletions