diff options
author | Yorhel <git@yorhel.nl> | 2020-06-04 11:26:49 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-06-04 11:26:51 +0200 |
commit | 50b9a5b7a59e896ed4a1f65141a31b8e64c33b55 (patch) | |
tree | 2375b4874d81271a99050b9673ba4d79682ce569 /util | |
parent | 3e2cacb826dc703b789d575c378f8dccb2dc95a6 (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.sql | 4 |
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(); |