Changeset 727

Timestamp:

01/06/2004 12:44:46 PM (22 years ago)

Author:

saxmatt

Message:

Reduce queries.

Location:

trunk

Files:

• wp-blog-header.php (modified) (2 diffs)
• wp-includes/template-functions.php (modified) (1 diff)

trunk/wp-blog-header.php

@@ -168 +168 @@
 if ('' != $category_name) {
     $category_name = preg_replace('|[^a-z0-9-/]|', '', $category_name);
+    $tables = ", $tablepost2cat, $tablecategories";
     $join = " LEFT JOIN $tablepost2cat ON ($tableposts.ID = $tablepost2cat.post_id) LEFT JOIN $tablecategories ON ($tablepost2cat.category_id = $tablecategories.cat_ID) ";
     $whichcat = " AND (category_nicename = '$category_name') ";
@@ -320 +321 @@
 $posts = $wpdb->get_results($request);
 
+
+// Get the categories for all the posts
+foreach ($posts as $post) {
+    $post_id_list[] = $post->ID;
+}
+$post_id_list = implode(',', $post_id_list);
+
+$dogs = $wpdb->get_results("SELECT DISTINCT 
+    ID, category_id, cat_name, category_nicename, category_description 
+    FROM $tablecategories, $tablepost2cat, $tableposts 
+    WHERE category_id = cat_ID AND post_id = ID AND post_id IN ($post_id_list)");
+    
+foreach ($dogs as $catt) {
+    $category_cache[$catt->ID][] = $catt;
+}
+
+// Do the same for comment numbers
+
+
 if (1 == count($posts)) {
     if ($p || $name) {

trunk/wp-includes/template-functions.php

@@ -1333 +1333 @@
 
 function get_the_category() {
-    global $post, $tablecategories, $tablepost2cat, $wpdb;
-    $categories = $wpdb->get_results("
-        SELECT category_id, cat_name, category_nicename, category_description 
-        FROM  $tablecategories, $tablepost2cat 
-        WHERE $tablepost2cat.category_id = cat_ID AND $tablepost2cat.post_id = $post->ID
-        ");
-
-    return $categories;
+    global $post, $tablecategories, $tablepost2cat, $wpdb, $category_cache;
+    if ($category_cache[$post->ID]) {
+        return $category_cache[$post->ID];
+    } else {
+        $categories = $wpdb->get_results("
+            SELECT category_id, cat_name, category_nicename, category_description 
+            FROM  $tablecategories, $tablepost2cat 
+            WHERE $tablepost2cat.category_id = cat_ID AND $tablepost2cat.post_id = $post->ID
+            ");
+    
+        return $categories;
+    }
 }