Changeset 5178

Timestamp:

04/04/2007 08:44:45 PM (17 years ago)

Author:

ryan

Message:

Cache category hierarchy to make cat listing faster. Phase 1. see #3985

Location:

trunk

Files:

• wp-admin/admin-functions.php (modified) (2 diffs)
• wp-includes/category.php (modified) (4 diffs)
• wp-includes/functions.php (modified) (1 diff)

trunk/wp-admin/admin-functions.php

@@ -792 +792 @@
         $categories = get_categories( 'hide_empty=0' );
 
+    $children = _get_category_hierarchy();
+
     if ( $categories ) {
         ob_start();
@@ -797 +799 @@
             if ( $category->category_parent == $parent) {
                 echo "\t" . _cat_row( $category, $level );
-                cat_rows( $category->cat_ID, $level +1, $categories );
+                if ( isset($children[$category->cat_ID]) )
+                    cat_rows( $category->cat_ID, $level +1, $categories );
             }
         }

trunk/wp-includes/category.php

@@ -110 +110 @@
     }
 
-    if ( $child_of || $hierarchical )
-        $categories = & _get_cat_children($child_of, $categories);
+    if ( $child_of || $hierarchical ) {
+        $children = _get_category_hierarchy();
+        if ( ! empty($children) )
+            $categories = & _get_cat_children($child_of, $categories);
+    }
 
     // Update category counts to include children.
@@ -261 +264 @@
 
     $category_list = array();
+    $children = _get_category_hierarchy();
     foreach ( $categories as $category ) {
         if ( $category->cat_ID == $category_id )
@@ -267 +271 @@
         if ( $category->category_parent == $category_id ) {
             $category_list[] = $category;
+            if ( !isset($children[$category->cat_ID]) )
+                continue;
+            
             if ( $children = _get_cat_children($category->cat_ID, $categories) )
                 $category_list = array_merge($category_list, $children);
@@ -314 +321 @@
 }
 
+function _get_category_hierarchy() {
+    $children = get_option('category_children');
+    if ( is_array($children) )
+        return $children;
+
+    $children = array();
+    $categories = get_categories('hide_empty=0&hierarchical=0');
+    foreach ( $categories as $cat ) {
+        if ( $cat->category_parent > 0 )
+            $children[$cat->category_parent][] = $cat->cat_ID;
+    }
+    update_option('category_children', $children);
+
+    return $children;
+}
 ?>

trunk/wp-includes/functions.php

@@ -750 +750 @@
     wp_cache_delete('all_category_ids', 'category');
     wp_cache_delete('get_categories', 'category');
+    delete_option('category_children');
 }