[pLog-svn] r2340 - plog/branches/plog-1.0.2/class/dao

oscar at devel.plogworld.net oscar at devel.plogworld.net
Fri Jul 15 19:58:20 GMT 2005


Author: oscar
Date: 2005-07-15 19:58:20 +0000 (Fri, 15 Jul 2005)
New Revision: 2340

Modified:
   plog/branches/plog-1.0.2/class/dao/articlecategories.class.php
Log:
added matt's optimizations to the queries to load blog categories, see http://bugs.plogworld.net/view.php?id=614


Modified: plog/branches/plog-1.0.2/class/dao/articlecategories.class.php
===================================================================
--- plog/branches/plog-1.0.2/class/dao/articlecategories.class.php	2005-07-15 06:22:07 UTC (rev 2339)
+++ plog/branches/plog-1.0.2/class/dao/articlecategories.class.php	2005-07-15 19:58:20 UTC (rev 2340)
@@ -167,8 +167,9 @@
 				          c.last_modification AS last_modification, c.in_main_page AS in_main_page, 
 						  c.parent_id AS parent_id, c.description AS description, c.properties AS properties, 
 						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update 
-						  FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
-						  ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id 
+						  FROM {$prefix}articles a
+						  LEFT JOIN {$prefix}articles_categories c ON c.id = l.category_id
+						  LEFT JOIN {$prefix}article_categories_link l ON a.id = l.article_id
 						  WHERE c.blog_id = '".Db::qstr($blogId)."'";
 						  
 			if( $onlyInMainPage )
@@ -210,8 +211,9 @@
 				          c.last_modification AS last_modification, c.in_main_page AS in_main_page, 
 						  c.parent_id AS parent_id, c.properties AS properties, c.description AS description,
 						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update 
-						  FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
-						  ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id 
+						  FROM {$prefix}articles a
+						  LEFT JOIN {$prefix}articles_categories c ON c.id = l.category_id
+						  LEFT JOIN {$prefix}article_categories_link l ON a.id = l.article_id
 						  WHERE c.blog_id = $blogId";
 						  
 			if( $onlyInMainPage )
@@ -478,9 +480,10 @@
 			$query = "SELECT a.id as article_id, c.id AS id, c.name AS name, c.url AS url, c.blog_id AS blog_id, 
 				          c.last_modification AS last_modification, c.in_main_page AS in_main_page, 
 						  c.parent_id AS parent_id, c.properties AS properties, c.description AS description,
-						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update 
-						  FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
-						  ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id 
+						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update 						  
+						  FROM {$prefix}articles a
+						  LEFT JOIN {$prefix}articles_categories c ON c.id = l.category_id
+						  LEFT JOIN {$prefix}article_categories_link l ON a.id = l.article_id						  
 						  WHERE a.id IN (".$articleIds.") ";
 			if( $blogId > -1 ) {
 				$query .= " AND a.blog_id = '".Db::qstr( $blogId )."' AND c.blog_id = '".Db::qstr( $blogId )."'";	




More information about the pLog-svn mailing list