[Librefm-commits] [1171] Improve performance on scrobbles-track joins

[Clint Adams]

Revision: 1171
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1171
Author:   clint
Date:     2009-05-03 22:18:59 +0000 (Sun, 03 May 2009)
Log Message:
-----------
Improve performance on scrobbles-track joins

Modified Paths:
--------------
    trunk/nixtape/data/Server.php

Modified: trunk/nixtape/data/Server.php
===================================================================
--- trunk/nixtape/data/Server.php       2009-05-03 22:15:32 UTC (rev 1170)
+++ trunk/nixtape/data/Server.php       2009-05-03 22:18:59 UTC (rev 1171)
@@ -66,10 +66,10 @@
                                LEFT JOIN Album l
                                        ON l.artist_name=s.artist
                                        AND l.name=s.album
+                               LEFT JOIN Scrobble_Track st
+                                       ON s.stid = st.id
                                LEFT JOIN Track t
-                                       ON lower(s.artist) = lower(t.artist)
-                                       AND lower(s.album) = lower(t.album)
-                                       AND lower(s.track) = lower(t.name)
+                                       ON st.track = t.id
                                WHERE lower(s.username) = " . 
$mdb2->quote(strtolower($username), "text") . ' 
                                ORDER BY
                                        s.time DESC 
@@ -94,10 +94,10 @@
                                LEFT JOIN Album l
                                        ON l.artist_name=s.artist
                                        AND l.name=s.album
+                               LEFT JOIN Scrobble_Track st
+                                       ON s.stid = st.id
                                LEFT JOIN Track t
-                                       ON lower(s.artist) = lower(t.artist)
-                                       AND lower(s.album) = lower(t.album)
-                                       AND lower(s.track) = lower(t.name)
+                                       ON st.track = t.id
                                ORDER BY
                                        s.time DESC 
                                LIMIT " . $mdb2->quote($number, "integer"));