Changeset 4450 for trunk/wp-includes/query.php

Timestamp:

11/07/2006 11:43:59 PM (20 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) )