summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-11-11 20:15:12 +0100
committerYorhel <git@yorhel.nl>2010-11-11 20:15:12 +0100
commit3bf6e39ab20d106152f2016ccf6eae26e844d846 (patch)
treef5f60afa244814d9b055f4301e6fe8f2ee239f34
parent03535e51f5b600518dc3e3b3459df869f0166e5d (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.pm2
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} ? (