Changeset 1673 for trunk/gregarius/cls

Timestamp:

01/15/07 09:21:41 (21 months ago)

Author:

mbonetti

Message:

optimization: the join on the ratings table would take quite some time. Commented it out as we're not using ratings atm

Files:

• trunk/gregarius/cls/items.php (modified) (1 diff)

trunk/gregarius/cls/items.php

@@ -288 +288 @@
             ."i.url, i.enclosure, i.author, i.description, c.icon, "
             ." unix_timestamp(ifnull(i.pubdate,i.added)) as ts, "
-            ." i.pubdate is not null as ispubdate, i.id, r.rating  ";
+            ." i.pubdate is not null as ispubdate, i.id "
+            ." , null "
+            //.", r.rating  "
+            ;
         $this -> _sqlActualFrom =   getTable("item") ." i "
-            ." left join " . getTable("rating") ." r on (i.id = r.iid) "
+            //." left join " . getTable("rating") ." r on (i.id = r.iid) "
             ." inner join " . getTable("channels")." c on (c.id = i.cid) "
             ." inner join " . getTable("folders") ." f on (f.id = c.parent) ";