Changeset 4450

Timestamp:

11/07/2006 11:43:59 PM (18 years ago)

Author:

ryan

Message:

GROUP BY is hella faster than DISTINCT.

File:

• trunk/wp-includes/query.php (modified) (4 diffs)

trunk/wp-includes/query.php

@@ -584 +584 @@
         $join = '';
         $search = '';
+        $groupby = '';
 
         if ( !isset($q['post_type']) )
@@ -802 +803 @@
             }
             $whichcat = $in_cats . $out_cats;
-            $distinct = 'DISTINCT';
+            $groupby = "{$wpdb->posts}.ID";
         }
 
         // Category stuff for nice URLs
-
-        global $cache_categories;
         if ('' != $q['category_name']) {
             $reqcat = get_category_by_path($q['category_name']);
@@ -837 +836 @@
             $whichcat = substr($whichcat, 0, -2);
             $whichcat .= ")";
-            $distinct = 'DISTINCT';
+            $groupby = "{$wpdb->posts}.ID";
         }
 
@@ -976 +975 @@
         // manipulate paging queries should use these hooks.
         $where = apply_filters('posts_where_paged', $where);
-        $groupby = '';
         $groupby = apply_filters('posts_groupby', $groupby);
         if ( ! empty($groupby) )