summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-03-28 15:10:33 +0100
committerYorhel <git@yorhel.nl>2009-03-28 15:59:11 +0100
commit864bce475636282e31643cbbb8cab2fc9ac47ce0 (patch)
tree49c3b3ee4b4d4235935230f4c5197fc2e73c66b5 /lib
parent6fcc794b5a5c3a671dfc89aa343f553c2b034501 (diff)
Fixed and re-organized tag<->vn calculation
Fixed major performance bug caused by referencing the wrong table, moved all intermediate views to tag_vn_calc() as temporary views (similar to update_vnpopularity()) and renamed tags_vn_stored to tags_vn_bayesian.
Diffstat (limited to 'lib')
-rw-r--r--lib/VNDB/DB/Tags.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Tags.pm b/lib/VNDB/DB/Tags.pm
index a24495cf..280f3f3e 100644
--- a/lib/VNDB/DB/Tags.pm
+++ b/lib/VNDB/DB/Tags.pm
@@ -205,7 +205,7 @@ sub dbTagVNs {
my($r, $np) = $self->dbPage(\%o, q|
SELECT tb.tag, tb.vid, tb.users, tb.rating, tb.spoiler, vr.title, vr.original, v.c_languages, v.c_released, v.c_platforms, v.c_popularity
- FROM tags_vn_stored tb
+ FROM tags_vn_bayesian tb
JOIN vn v ON v.id = tb.vid
JOIN vn_rev vr ON vr.id = v.latest
!W