diff options
author | Yorhel <git@yorhel.nl> | 2019-10-07 12:02:55 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-10-07 12:10:02 +0200 |
commit | bf734c442f14d32a166034ebc076c84b52b07840 (patch) | |
tree | 1707c6ff571ce3c44eb8edd6e4118041cdd27ae9 /lib | |
parent | 4844a42cb554253340391fdbdc5a7634ee287b1e (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