diff options
author | Yorhel <git@yorhel.nl> | 2010-11-11 20:15:12 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-11-11 20:15:12 +0100 |
commit | 3bf6e39ab20d106152f2016ccf6eae26e844d846 (patch) | |
tree | f5f60afa244814d9b055f4301e6fe8f2ee239f34 | |
parent | 03535e51f5b600518dc3e3b3459df869f0166e5d (diff) |
DB::Releases: Removed extra ON clause from JOIN releases
I added this clause to slightly speed up the SQL query at producer
pages, but it turns out to slow down release search queries by a factor
100.
-rw-r--r-- | lib/VNDB/DB/Releases.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm index be954bd8..01ca6b44 100644 --- a/lib/VNDB/DB/Releases.pm +++ b/lib/VNDB/DB/Releases.pm @@ -62,7 +62,7 @@ sub dbReleaseGet { } my @join = ( - $o{rev} ? 'JOIN releases r ON r.id = rr.rid' : 'JOIN releases r ON rr.id = r.latest AND rr.rid = r.id', + $o{rev} ? 'JOIN releases r ON r.id = rr.rid' : 'JOIN releases r ON rr.id = r.latest', $o{vid} ? 'JOIN releases_vn rv ON rv.rid = rr.id' : (), $o{pid} ? 'JOIN releases_producers rp ON rp.rid = rr.id' : (), $o{what} =~ /changes/ || $o{rev} ? ( |