summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-06-04 11:26:49 +0200
committerYorhel <git@yorhel.nl>2020-06-04 11:26:51 +0200
commit50b9a5b7a59e896ed4a1f65141a31b8e64c33b55 (patch)
tree2375b4874d81271a99050b9673ba4d79682ce569 /util
parent3e2cacb826dc703b789d575c378f8dccb2dc95a6 (diff)
Cache VN popularity & rating rankings
Should shave off about 10-30ms of the VN page generation times.
Diffstat (limited to 'util')
-rw-r--r--util/updates/2020-06-04-vn-ranking-cache.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/2020-06-04-vn-ranking-cache.sql b/util/updates/2020-06-04-vn-ranking-cache.sql
new file mode 100644
index 00000000..3eb02392
--- /dev/null
+++ b/util/updates/2020-06-04-vn-ranking-cache.sql
@@ -0,0 +1,4 @@
+ALTER TABLE vn ADD COLUMN c_pop_rank integer;
+ALTER TABLE vn ADD COLUMN c_rat_rank integer;
+\i sql/func.sql
+select update_vnvotestats();