diff options
author | Yorhel <git@yorhel.nl> | 2009-03-28 15:10:33 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-03-28 15:59:11 +0100 |
commit | 864bce475636282e31643cbbb8cab2fc9ac47ce0 (patch) | |
tree | 49c3b3ee4b4d4235935230f4c5197fc2e73c66b5 /lib | |
parent | 6fcc794b5a5c3a671dfc89aa343f553c2b034501 (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.pm | 2 |
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 |